I'm not sure if this is a join problem or even if it can be done.
The english part of the query will be requesting cagegoires="Cat2"
and return the matching records in table1, plus return all the other
categories that belong to the set in table 2.
should return two records..
1 document1 Cat1 Cat2 Cat3
2 document2 Cat1 Cat2
table 1
ID int DOC char(20)
1 document1
2 document2
table 2
ID int Category char(4)
1 Cat1
1 Cat2
1 Cat3
2 Cat1
2 Cat2
Re: Two queries ..."John Vinson" wrote: ... > Info and matching records in Allocated". ... > nonexistant records by the outer join) and convert it to a zero.... How do I also have the query do as above but if product is allocated take ... (microsoft.public.access.queries)
Re: New records cant be seen ... Your query here is matching records in the "client" table with the records ... To do so, create a new query....Finances ON Client.MasterID = Finances.MasterID ... (microsoft.public.access.forms)
Re: Matching records table in a multi-user environment ... > I use a matching records table to select records in a query.... > multi-user environment where all objects are in a shared database.... Is it possible for someone to overwrite the matching records table ...Windows LogInID to distinguish Records belonging to a ... (microsoft.public.access.queries)
Re: Compare 2 files and delete ...>append wizard but not in the delete wizard. ... create a Query joining the two tables by that field. ... you want to delete from> and matching records in ". ... the Show box under the field with the "is null" criterion.... (microsoft.public.access.queries)
Joining 3 tables in a query ... I am joining 3 tablesin a query, but it's only pulling matching records in ... include incentives for 2004 models and 2005 models. ... also have 2005 incentives table joined to "Total Inventory" via "2005 ... Incentive tables in order for the query to pull the matching records.... (microsoft.public.access.queries)
