query to find when an event happened

[Bob H]

I have 12 years of weather data in one table, and have queries to give
me total rainfalls between different dates etc, as well as max and min
temperatures.
What I would like now is a query to tell me what date in a selected
range the max or min temperature was.
I have tried the WHERE clause just see what it would return but I got a
syntax error.

Thanks

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) queryat:
http://www.mvps.org/access/queries/qry0020.htm

 

[Bob H]

Thanks for the link, but I can only get as far as the first query, where
it gives me the dates where we had rain, all 1100 of them. I can't
work out how to get the highest value of rainfall along with the date it
fell.

Thanks

 

[Allen Browne]

In essence, you use a Totals query to get the highest rainfall in the
period.

Then you use a subquery or a DLookup() expression to look up what the date
was that recorded the highest rainfall in the period. If subqueries are the
issue, here's an introduction:
http://allenbrowne.com/subquery-01.html

If you need to use DLookup():
http://allenbrowne.com/casu-07.html

 

[Dale Fye]

Bob,

It would be helpful if you would post the query you have. Trying to provide
you with a solution, without knowing what you are currently working with is a
real challenge.

 

[Bob H]

Dale, I managed to get this problem sorted now, thanks.
I ended up with just a simple query and using SELECT MAX to get what I
wanted. I've also used SELECT MIN for the minimum temperatures.

Thanks anyway