Mr Celko

I researching some of your suggestions, I have stumbled upon your series Stairway to Database design. As I prepare to retire I have a home weather station...

I certainly apologizes for my ineptitude. 

I am about as far from  an SQL programmer as you can get, I am in fact not a programmer at all. I...

Thank you so much for that help

Thank you so much for your help and the useful tip.

Taking your advice I have moved to the query editor and just trying to converter 1 value for now there is still something I am not doing correctly. In this...

Thank you for your help.

I did that but it returned every record. It viewed each temp for each time period to be the max temp.