Nicholson, Karen
cyx5 at cdc.gov
Thu May 19 13:27:29 CDT 2005
It looks like this was created flat for some reason; maybe because the user only wants to allow the selection of six items per invoice, but there are other ways to limit product selections. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, May 19, 2005 2:22 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Avoiding Duplicates on a Report Hi Mike: I got into this late and I may not understand these issues but should not each of the invoice detail items be in their own separate record? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W Sent: Thursday, May 19, 2005 7:26 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Avoiding Duplicates on a Report This don't work because the product I search for could be in any of 6 fields, Product1 thru Product6. Mike Gowey MCDST, A+, LME, NET+ Team Leader - East Region Information Systems Unit Office - (541)881-4808 Fax - (541)881-5471 Pager - 1-888-320-2545 epage - 8883202545 at archwireless.net -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Thursday, May 19, 2005 8:18 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Avoiding Duplicates on a Report Won't a GROUP BY on the Customer and Product work? Susan H. Here is my scenerio - I have a sales table which records the purchase of a product by a customer. It logs the product, cutomer# & Invoice#. Now I want to be able to pull from the table all customers who purchased a certain product. The part I need help with is trying to pull the customer only once. The same customer could purchase the same product more than once during the month but I only want the query to show me the customer# & product only once, not multiple times. Any advice would be greatly appreciated. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com