Minimum and Maximum

[mr_connell]

I have a list of dates in a Field.

I want to run a query that only shows the earliest date and the latest date.
How would i do that?
I've tried the minimum and maximum options but maybe i'm not typing the expression right in the criteria.
Please help?

 

[Norie]

Do you mean you have more than 1 date in this field?

 

[mr_connell]

Not in the same field, i'm sorry.
The dates are in the same column in the table.

 

[Joe4]

Use an Aggregate Query. Check out "Perform calculations in a query" in Access help. There is a Min and Max option.