Finding first date

[Sara Overton]

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?

 

[Rich]

You could sort the date field descending.
HTH

 

[Sara Overton]

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).]

 

[Axis]

Use Min instead of First.