removing extra data from reports.

  • Thread starter Thread starter Adrian Brown
  • Start date Start date
A

Adrian Brown

Ive got a report system working nicely now (Thanks to many people here), but
now the end user has changed their mind again. At present it lists clients
name/address and product for each product. Due to the data a single client
may have many products but at present it just displays multiple entries i.e.

John Smith 27 Some Address 200 Fishtanks
John Smith 27 Some Address 300 Lightbulbs
Jo Franklin 101 Somewhere Else 100 Fishtanks
John Smith 27 Some Address 20 Plugs


etc

They would prefer it to be

John Smith 27 Some Address 200 Fishtanks
300 Lightblubs
20 Plugs

Jo Franklin 101 Somewhere Else 100 Fishtanks

I can group the items together but how would i go about stopping it printing
the extra name/addresses

Many Thanks

Adrian
 
Use the group header and put the name and address in the header (only), then
the items in the detail section.

..
 
2 options:

In the Properties for your name and address fields, set Hide Duplicates = Yes.

or

You used the right words "group the items together". You can go to View,
Sorting and Grouping.

HTH,
Debbie


| Ive got a report system working nicely now (Thanks to many people here), but
| now the end user has changed their mind again. At present it lists clients
| name/address and product for each product. Due to the data a single client
| may have many products but at present it just displays multiple entries i.e.
|
| John Smith 27 Some Address 200 Fishtanks
| John Smith 27 Some Address 300 Lightbulbs
| Jo Franklin 101 Somewhere Else 100 Fishtanks
| John Smith 27 Some Address 20 Plugs
|
|
| etc
|
| They would prefer it to be
|
| John Smith 27 Some Address 200 Fishtanks
| 300 Lightblubs
| 20 Plugs
|
| Jo Franklin 101 Somewhere Else 100 Fishtanks
|
| I can group the items together but how would i go about stopping it printing
| the extra name/addresses
|
| Many Thanks
|
| Adrian
|
|
 
Works like a dream. Why is it some things i assume will be hard are really
simple, yet other things that seem like they should be easy are nearly
impossible :) The wonders of access :D

Adrian
 
Back
Top