Query to return unmatched records?


J

Jim Shaw

BlankHow do I create a query which will return unmatched records in the left
side of a 1:[0,1] relationship?

My need is to add a record to the right side table that will join (in
another query) to the record on the left side table. My logic needs to find
candidate, unmatched records in the left table so they may be listed in a
combo box, allowing the user to select the candidate of choice. I plan to
use the SQL for this in my combo box's Row Source.

Thanks
-Jim Shaw
 
Ad

Advertisements

D

Douglas J. Steele

There's a "Find Unmatched Query Wizard" available when you create new
queries.
 
G

Guest

Doug;
Thanks for this tip. I have been racking my brain trying to write the SQL from scratch!

Happy new year!
Skip Shein
Glenview, Illinois
 
J

Jim Shaw

Thank you.
And now to reference the left table as the current recordset underlying
myForm having the option box whose list I'm trying to load with the query
results. I'm trying to use a unmatched query in the row source.
How do I do that?
-Jim


Douglas J. Steele said:
There's a "Find Unmatched Query Wizard" available when you create new
queries.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Jim Shaw said:
BlankHow do I create a query which will return unmatched records in the left
side of a 1:[0,1] relationship?

My need is to add a record to the right side table that will join (in
another query) to the record on the left side table. My logic needs to find
candidate, unmatched records in the left table so they may be listed in a
combo box, allowing the user to select the candidate of choice. I plan to
use the SQL for this in my combo box's Row Source.

Thanks
-Jim Shaw
 
Ad

Advertisements

D

Douglas J. Steele

Don't think you can. You'll have to create a query that generates that
recordset, and use that query in the unmatched query.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Jim Shaw said:
Thank you.
And now to reference the left table as the current recordset underlying
myForm having the option box whose list I'm trying to load with the query
results. I'm trying to use a unmatched query in the row source.
How do I do that?
-Jim


Douglas J. Steele said:
There's a "Find Unmatched Query Wizard" available when you create new
queries.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Jim Shaw said:
BlankHow do I create a query which will return unmatched records in
the
left
side of a 1:[0,1] relationship?

My need is to add a record to the right side table that will join (in
another query) to the record on the left side table. My logic needs
to
find
candidate, unmatched records in the left table so they may be listed
in
plan
 

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

Top