Query Design Help

[Frolickin]

I am struggling with how to create a query I desire.

Table1 contains the following fields:

autoID, cachename (text), county (text) and some other fields that are not
needed for this example

Table2 contains the following fields:

autoID, cacher (text), cachename(text), finddate (date/time)

cachename in Table2 is linked to a query of Table1.



What I want to do is create two queries:

one that will list a cacher and all cachenames found in a specific county

one that will list a cacher and all cachenames not found in a specific
county.

I have created a query of Table1 that lists all cachenames in a specific
county. How can I use this to generate the two queries above? Or maybe I
need to take another approach . . .

 

[Jeff Boyce]

I assume "cachename" is a unique value, not shared by more than one
"cacher".

You didn't say so, but I assume the second table indicates "found" caches.

(see in-line)

What I want to do is create two queries:

one that will list a cacher and all cachenames found in a specific county

Join table2 to table1. Select cacher (table2), cachename (table2), county
(table1). Enter the county you want to specify in the criterion "cell"
under the "county" field.

one that will list a cacher and all cachenames not found in a specific
county.

?Not found by whom? Or not found at all?

 

[Frolickin]

-----Original Message-----

I assume "cachename" is a unique value, not shared by more than one "cacher".

You didn't say so, but I assume the second table

indicates "found" caches.

I was not clear. Sorry.

"cachename" is not unique in table1. That is why I have
used the autoID. The same cachename could be used twice.
If it had to be unique, I could make it so. There is
only one instance where two names are the same.

The idea is that in table2, "cacher" can find
some "cachename", but not necessarily all. I would like
to be able to derive both sets: the "cachename"
the "cacher" found in a specific county and
the "cachename" the "cacher" didn't find in a specific
county.

?Not found by whom? Or not found at all?

Not found by whom