CumbrianCanary
Registered User.
- Local time
- Today, 22:57
- Joined
- Sep 13, 2004
- Messages
- 22
I have been asked by a colleague to help with a database that I have not been involved in designing.
It has data weather data for a number of times for every day. They wanted to get out the max wind speed for every day. This was easily achieved by using the Group By Day and Max wind speed in the basic query design window.
They would now like the direction associated with that speed. I can’t seem to do this easily using the standard query window. Could anyone help me please?
Thanks
CC
It has data weather data for a number of times for every day. They wanted to get out the max wind speed for every day. This was easily achieved by using the Group By Day and Max wind speed in the basic query design window.
They would now like the direction associated with that speed. I can’t seem to do this easily using the standard query window. Could anyone help me please?
Thanks
CC