Query to return unmatched records?

[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

 

[Douglas J. Steele]

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

 

[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

 

[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

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

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

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

 

[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)

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

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

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

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

plan

to