G Guest Jun 20, 2006 #1 I would like to create a query to pull out records that do not have a record in a related table, could anyone assist me on this?
I would like to create a query to pull out records that do not have a record in a related table, could anyone assist me on this?
A Allen Browne Jun 20, 2006 #2 When you create a new query, one of the options Access offers is called: Unmatched Query Wizard. Put him to work.
When you create a new query, one of the options Access offers is called: Unmatched Query Wizard. Put him to work.
G Guest Jun 20, 2006 #3 Allen, I hoped it would be something simple, didn't realise it would be quite so simple. I've always refused to use the wizards, I feel its time I changed my mind! Thanks for your assistance. MBraybrook
Allen, I hoped it would be something simple, didn't realise it would be quite so simple. I've always refused to use the wizards, I feel its time I changed my mind! Thanks for your assistance. MBraybrook