I'm creating queries in an air quality monitoring database that will check for a set of validation criteria, such as: did the sample run the proper amount of time? I have a query set up now with the fields I need: Filter ID (with a parameter set to prompt user for filter ID they are checking on) and ElapsedTime (with criteria of <23 or >25). The idea here is to come up with an empty query result, which means that your filter DID run the correct amount of time, however the catch 22 is: is there any way I can verify that the user entered a valid filter ID (if they didn't, they'd still come up with an empty query result)????
PS Running the query the reverse way, where no parameter is set on FilterID will not be an ideal set up because some folks will have hundreds or thousands of records.
PS Running the query the reverse way, where no parameter is set on FilterID will not be an ideal set up because some folks will have hundreds or thousands of records.
