See all records

[LED]

Hi,
Was wondering if someone could help me out.

I have two tables.
The first one is Customers (500 records)
The second one is Gift Cards (125 records)

The customer # is in both tables.

As you can see, not all the customers have purchased a Gift Card.

What I am trying to do is create a query that lists all the customers (500
of them) whether they purchased a gift card or not........and if they did
purchase a gift card, then what is the provide me with the gift card
information for those 125.

Seems like it would be simple.....but I can't get it.
If you could help, it would be appreciate. Thanks!

 

[KARL DEWEY]

Create a query using your Customers table. Open in design view and add the
Gift Cards table.
Click on the Customers table field that matches the Gift Cards table field.
Drag from Customers table to Gift Card table field. Double click on the
connecting line. Select the one that says to show all Customer records and
only those of the Gift Card table that match.

 

[Klatuu]

In your query designer, right click on the line that joins the two tables.
There will be the option buttons. Select the one that says to show all
records in the customer table and only the matching records in the giftcards
table.

 

[LED]

Thank you....that was new to me and what an awesome piece of knowledge. I
appreciate it.

That worked!!!

 

[LED]

Thank you.....that is exactly what worked.......Thanks for your time and
knowledge.