Exist in one table but not another

[ecugrad]

I have a two tables a Review table and Account table with the relationship being the account number and note number. I want to return all records that exsist in the Account table, but are not in the Review table. Sounds easy, but I'm having difficulties.

Thanks

ACCESS 2003

 

[dhookom]

Did you try using the new query wizard that does this?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]