turkishgold
Registered User.
- Local time
- Yesterday, 18:16
- Joined
- Aug 25, 2009
- Messages
- 17
Hi,
I'm trying to figure out how to do what I guess you would call a pairwise query, where for example you have a column called Parameter that contains various codes for water quality parameters. Then, you have a column in the Access General Date format for Dates those parameters were sampled.
How would you write a query that would return records showing only, in this case, the records associated with two (or perhaps more than two) specific parameter codes (in the Parameter column as text strings) if they were sampled on the same Date/Time?
This has to be fairly simple but the logic is escaping me...
thanks
Tom
I'm trying to figure out how to do what I guess you would call a pairwise query, where for example you have a column called Parameter that contains various codes for water quality parameters. Then, you have a column in the Access General Date format for Dates those parameters were sampled.
How would you write a query that would return records showing only, in this case, the records associated with two (or perhaps more than two) specific parameter codes (in the Parameter column as text strings) if they were sampled on the same Date/Time?
This has to be fairly simple but the logic is escaping me...
thanks
Tom