access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to return unmatched items in a database to give total picture instread of
just matched items
 
You need to be more explicit. "items in a database" could mean forms,
reports, tables, queries,... in your MDB file.

If you mean records in a table then consider using the unmatched query
wizard.
 
How to return unmatched items in a database to give total picture instread of
just matched items
Click to expand...

You're talking to human beings, not to a search engine. Please ask
your question on that basis - i.e. with a bit more background!

I'm *guessing* that you want an Outer Join. If you have TableA related
one to many to TableB, but you want to see all records in TableA
regardless of whether they have matching records in TableB, select the
join line in the query grid and choose Option 2 - "Show all records in
TableA and matching records in TableB".

If you're asking something else - please ask again, clearly.

John W. Vinson[MVP]
 
Back
Top