Trying to return the 1st date value greater than a starting date v

[Guest]

I am working with a query trying to return the earliest date greater than a
specific start date.

Example...
Start date = 1/1/2006

meter read dates = 12/30/2005, 1/30/2006, 2/27/2006

I want to return only the 1st meter read date > the start date

I keep thinking this should not be that difficult and that I am overlooking
something obvious

Thanks for any help you can offer

 

[guido]

You would put ">#1/1/2006#" as criteria for the meter read date field, change
the query to a "group by" query and select "Min" in the meter read date field.

 

[Guest]

Hi,
I had to use the Totals function. Then I selected the date field and used
the Min function with the Show box checked.
Then I selected the date field again, used the Where function, and unchecked
the Show box.

Cheers.