Search results

I am just trying to learn to use queries for data management and yes I'm definitely working on a copy. The actual database is safe from my edits! Thanks to you and Pat Hartman for suggestions and key points! I'll look into that and try to make changes accordingly!

@jdraw: I have attached few examples of what my data looks like, Data_logger table: This table has all the hourly data including columns for site_serial (unique for each gage), date-time, uncompensated water levels (in the original code referred to as ch1_data_P), barometric pressure (in the...

Okay, I can understand! I'll try to give a simple explanation. I simply want to calculate daily average water levels from the hourly records for each measuring site. About the "acceptable data range", the device that measures atmospheric pressure (barologger) can sometimes give a bad data value...

I have two tables: logger_data and MPCable. Logger_data table has hourly gage data records consisting of columns for site_serial (unique for each gage), date-time, water pressure (ch1_data_P), barometric pressure (ch2_data_P), temperature, and other not so very important data. MPCable table has...

Thank you all for your input and apologies for late response! I looked at the data and as most of the comments pointed out, there's no need to have an individual query for each gage station. I worked on it and created a single query using switch and IIf function. My approach is very basic and I...

Ah! Good to know

I have several queries for each gaging stations that are run to update the data table. All of these queries have a similar structure except for range values, site serials, and CountyID. How do I combine these queries to form a single query that would update records for all the gages? For Gage1...