Re: Don't Repeat Record?

From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 15:44:42 GMT

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.

On Thu, 30 Dec 2004 05:37:02 -0800, ThePro
<ThePro@discussions.microsoft.com> wrote:

>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

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security