Filtering by time: looking for max/min within a time interval

[Brianwarnock]

I. like all the other posters here, are just happy to help. Mind you home made cookies hmm, however from the times that you are on I guess that you live on the West Coast of the US , a bit far to go even for home made cookies.

If you wish to put all of your results together then a simple UNION query such as

SELECT [Final query for CH H].*
FROM [Final query for CH H]
UNION SELECT [Final query for CH HH].*
FROM [Final query for CH HH]
UNION
etc

will do it

I presume that you will redo the queries with your original Table names.

Brian

 

[judehamilton]

I am so happy right now I could burst. I have learned so much from you and will be forever grateful...I am in Oregon, and probably it is ridiculous to consider sending cookies to the other side of the globe, but maybe I'll make them for you and give them to someone else, hmmm? Many, many thanks to you!