Search results

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...

Hi, I'm trying to devise a query which will result in showing records based on result values that equal another distributing sources result values. So, I want to select the result values from the table from a particular "agency", and then based on that subquery, use that to narrow down the...

Hi, I'm having some difficulty with a multiple nested query in access. Here's what I have so far: SELECT Sample.site_id, Sample.dt_tm, Sample.collecting_agency, Sample.sample_id FROM Sample WHERE ((Sample.site_id) In (SELECT [Sample.site_id] FROM [Sample] INNER JOIN Sites ON Sample.site_id =...