access

N

Noonan

How to return unmatched items in a database to give total picture instread of
just matched items
 
D

Duane Hookom

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

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
formatting questions 7
Incone & Expenses Statement 0
Anchor issue with inserting a shape for letterhead 1
Blocking users from outside office 0
Query-finding umatched data with duplicates 5
List Listbox items in column by macro 0
composite key unmatched query 1

Top