URGENT HELP NEEDED

  • Thread starter Thread starter Jagroop Moore via AccessMonster.com
  • Start date Start date
J

Jagroop Moore via AccessMonster.com

I have a customer table and a transaction table. and i need to find which
customer ids are in the customer table but not in the transaction table
 
Jagroop Moore via AccessMonster.com said:
I have a customer table and a transaction table. and i need to find which
customer ids are in the customer table but not in the transaction table
Click to expand...

Run the Find Unmatched Query Wizard. To start it, go to the Query section
click on New and it will be one of the choices in the New Query window.
From there, it walks you through creating the query you need.

Tom Lake
 

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

Similar Threads

How do I query a calculated control? 1
which customers have no transactions in the last year 3
Access Updating inventory levels 0
Detecting Calculated Sum in Rolling Time Period 0
Display columns without data in cross tab query 4
Compare current month totals with last months totals 1
Getting only the last transaction for each customer 1
Update Query - Want to Update Only the First Match 4

Back
Top