displaying only fields that meet find criteria

[oilman]

I have a db that has 33 records and each record has five date fields. I would like to displayed only the fields and not the whole record that meets the find criteria.

I have made a list view form and install all five dates in it. When FM has found a set it displays all the dates. Is there a way of doing this by script.

Example:

Criteria date 7/12/02

Field one date 7/12/02

Field two date 7/18/02

Field three date 8/02/02

Field four date 7/12/02

field five date 10/12/02

I would like to see just the dates that meet the criteria displayed. Not all the records will have the same dates.

thanks

[Alan Betts]

Try using calculations as your dates to view in the list.

e.g Date to view1 = If(date1<>criteria date;TextToDate("");date1)

etc etc.

Hope this helps

Alan

[Vaughan]

This should have been done as relational: the dates should be in a separate file.

[oilman]

thanks Alan

works like a charm