SUBDATASHEETS

G

geeves1293

I have got two tables which are related.

The first has is an Orders Table.

The second, an Orders Detail Table.

Can I create a select query showing me the Orders which have no link to
Order Details. Basically Orders with no detail.

Thanks

Geeves1293
 
A

Allen Browne

When you create a new query, the first dialog gives you the choice of:
Unmatched Query Wizard

Use the Wiz. to create the query for you.
 
Top