all records for a given date....

[kazza]

Im trying to do a report that shows info from a files records for a certain date. i set up a relationship between the date and the files records dates. and then used this relationship to get the needed fields. Which works but only for the first record.

To make it a bit more abstract: i have file1 and file2. In file2 i want a rport with file1's records for a given date.

Help!!! Please!!!

[Genx]

... I'm a bit confused about what your trying to do, could you expand a bit more? On a general note though you should know that you can only do reports out of a single table using only the fields for sorting etc. Information can only be pulled from related tables to do with the particular sorted records.

I know this doesnt really help you, so reply to my post with a better explanation and maybe some one else will...

Genx