[AccessD] Avoiding Duplicates on a Report

Another solution would be to write 6 queries; query 1 on customer and
product fld1, query 2 on customer and product fld2, etc. and then create a
union query based on the six queries. This may be slow or may not work if
the tables are massive.
Jim Hale

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Thursday, May 19, 2005 9:55 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Avoiding Duplicates on a Report


 
Thanks everyone for the advice, I will certainly look at normalization.
But for now how do I do about concatenated??  I have not heard of this.

Thanks 

-----Original Message-----
From: Darsant Silverstring [mailto:darsant at gmail.com] 
Sent: Thursday, May 19, 2005 8:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Avoiding Duplicates on a Report

On 5/19/05, Gowey Mike W <Mike.W.Gowey at doc.state.or.us> wrote:
> 
> What do you mean by normalized?  The customer has the ability to 
> purchase up to 6 products on one invoice.  The table assigns the 
> invoice number and than records the products selected in the fields 
> Product1 thru Product6.  The customer# is pulled from the customer
table.
> 
> Mike Gowey  MCDST, A+, LME, NET+
> Team Leader - East Region
> Information Systems Unit
> 

In a normalized database, if the customer purcahses 6 products, there
would be a sub-table such as InvoiceDetails, where you would have the
InvoiceID and then a seperate record for each product purchased.

One of the problems with doing it as a field on the invoice is you end
up with hard limits (using a subtable, the user could in theory,
purchase as many or as few products as they want). There's many other
reasons for normalization but I think that's left for another day.

However, to the problem at hand, since the data is not normalized best
bet would be to fake it and concatenated the fields as suggested
earlier.
--
Darsant Silverstring 

"Peace cannot be kept by force. It can only be achieved by
understanding."
-Albert Einstein
--
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

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.