I have a major problem.

I have been running reports on a table to check the first date of a date field against records on their Account Number.

When I put first in the query window it actually brings up the last entry date for that Account Number.

Any ideas what I can do?

You could sort the date field descending.
HTH

Thanks for the quick reponse. Unfortunatley that doesn't work either.

The problem is it's showing the last date but if I filter off that Account Number it suddenly changes and shows me the first date!!!

[This message has been edited by Sara Overton (edited 07-16-2001).]

Use Min instead of First.