gmlwong
Registered User.
- Local time
- Today, 05:10
- Joined
- Feb 7, 2003
- Messages
- 48
VBA help?#$?#?!
I have a "Customers" report that displays customer demographic data as well as respective home inventory product information.
On the final report, what I would like to have displayed is only one occurence of each customer's demographic data and however many of the customer's inventory product data...
...Show "John Smith" of 123 Anywhere Street, AnyTown, NY 11011 as well as only one record occurence of Mr. Smith's phone#, email address, etc... but all of Mr. Smith's home inventory products including his registration fields for his new Stove, Refridgerator, HDTV, and Microwave.
The limit I'm at now, shows all duplicate data for all fields,which skews my grand total calculations at the end of this report.
I have a "Customers" report that displays customer demographic data as well as respective home inventory product information.
On the final report, what I would like to have displayed is only one occurence of each customer's demographic data and however many of the customer's inventory product data...
...Show "John Smith" of 123 Anywhere Street, AnyTown, NY 11011 as well as only one record occurence of Mr. Smith's phone#, email address, etc... but all of Mr. Smith's home inventory products including his registration fields for his new Stove, Refridgerator, HDTV, and Microwave.
The limit I'm at now, shows all duplicate data for all fields,which skews my grand total calculations at the end of this report.
