Recent content by Ecologist

Thanks, Paul. Its amazing what can be accomplished by bartering beer! Cheers!

Resolved! The column for times for 2010 hourly temperature readings included extra junk ("x/x/1900") that was not visible until the column was widened significantly, as if there were a few tab spaces between the junk date on the left side of the cell and the hh:mm:ss seen on the right side of...

HI Paul, Thanks for your reply. I'm a greenhorn, so apologies if I am not using the same terms you do. Unsure what you mean "what does the field contain that identifies a 2010 record" -- do you mean DATE? I have columns formatted for dates and am relating the date fields between three...

I have 2 particular data tables that I update annually, as more (weather) data become available. I have added records from 2007, 2008, 2009 and 2010. I can query these tables to display the 2007-2009 records, but the 2010 records do not show up. How do I "update" the query so that the output...