Dates

[Ricky21]

Hi,

This is probably really easy.

I have searched the fourm but with no luck.

I have a field in a table with dates in it. I want to set up a query and pull down the date field twice, and want the first to show just the earliest date and the second to show the latest date. Is there a way of doing this.

hope someone can help

Richard

 

[ColinEssex]

Min() and Max() functions?

Col