Don't Repeat Record?

[Guest]

I have a querie with 2 linked tables. One contains all of the invoices for
the customers [customers ID only] with the location they made the purchase
[multiple locations] and a table with the customers info [address, phone,
etc]. I was able to link them with no problem. The problem is that I don't
want the queire to repeat records. Obviously the invoice table needs to
repeat IDs since each customer has multiple invoices, but I don't want this
querie to repeat them since what I need is a list of customers which made a
purchase at one of our specific locations and their respective addressess.
Right now the querie is returning alot of info [alot of rows] since it's
repeating records.

Is this possible?

Thanks

 

[Jack MacDonald]

Working in the query grid, make a query of the two tables with just
the CustomerName and the Location fields. Apply a criterion to the
query to show just the purchases from the selected location. Then
click the "Sigma" (summation) button in the toolbar to change your
query into a Sum query. By default, Access will "Group By" the two
fields in your query, thus giving you a list of the customers who made
purchases at the selected location.

I have a querie with 2 linked tables. One contains all of the invoices for
the customers [customers ID only] with the location they made the purchase
[multiple locations] and a table with the customers info [address, phone,
etc]. I was able to link them with no problem. The problem is that I don't
want the queire to repeat records. Obviously the invoice table needs to
repeat IDs since each customer has multiple invoices, but I don't want this
querie to repeat them since what I need is a list of customers which made a
purchase at one of our specific locations and their respective addressess.
Right now the querie is returning alot of info [alot of rows] since it's
repeating records.

Is this possible?

Thanks

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security