I have an Access Database for water quality monitoring that has fields including Water Temperature, Dissolved Oxygen, pH, etc. Each record (monitoring event) should have a value for each of these fields, and if they do not, I need to quickly identify which records are missing any of these data points.
All of the information I need for this query is in a single table, and I have set up a query that selects the Client, Date, and each water quality parameter, which I can scan through and manually check for data gaps, however, I would ideally like a query that selects all records that have a data gap in any of the water quality parameter fields.
Is it possible to have a query that essentially says:
"SELECT tblSamplingFormData.Date, tblSamplingFormData,......
FROM tblSamplingFormData
WHERE (((tblSamplingFormData.TurbidityValue) Is Null) OR (tblSamplingFormData.pHValue) Is Null) OR (tblSamplingFormData.TempValue) Is Null...."
and so on for all of the water quality parameters?
So far, I haven't been able to get anything to work. The working SQL code that selects everything but doesn't filter out "non-null" records is below:
SELECT tblSamplingFormData.SampleDate, tblSamplingFormData.Agency, tblSamplingFormData.ProductsApplied, tblSamplingFormData.SampleType, tblSamplingFormData.WaterLeavingTreatmentAreaConfirmation, tblSamplingFormData.TurbidityValue, tblSamplingFormData.pHValue, tblSamplingFormData.SCValue, tblSamplingFormData.TemperatureValue, tblSamplingFormData.DOValue FROM tblSamplingFormData WHERE (((tblSamplingFormData.SampleDate)>#1/1/2017#) AND ((tblSamplingFormData.WaterLeavingTreatmentAreaConfirmation)<>2) AND ((tblSamplingFormData.TurbidityValue) Is Null));
Thanks!
Steve