CUSTOMISED GROUPING ON REPORT?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a report, based on a query which I have grouped on a field called
"source"
So each record with source = "Distributer" is displayed, followed by totals.
Then each record with source = "Vendor" is displayed followed by totals
and so on for each value that the Source field contains.

Now I am trying to customises the gouping, eg I want to display in the first
sections the records where soruce = "Distributer" OR source = "vendor, and
have totals for this.
in the next sections i want to display records where the source =
"Manufacturer" OR source = "Unknown" and have totals for this as well

Van anyone help?

Thanksyou so much for any help you can give

Cheers
 
confused said:
I have a report, based on a query which I have grouped on a field called
"source"
So each record with source = "Distributer" is displayed, followed by totals.
Then each record with source = "Vendor" is displayed followed by totals
and so on for each value that the Source field contains.

Now I am trying to customises the gouping, eg I want to display in the first
sections the records where soruce = "Distributer" OR source = "vendor, and
have totals for this.
in the next sections i want to display records where the source =
"Manufacturer" OR source = "Unknown" and have totals for this as well
Click to expand...


I would create a small table to define which source values
are to be grouped together:

"Distributer" 1
"vendoe" 1
"Manufacturer" 2
"Unknown" 2

Then Join this table to the report's recordsource
table/query on the source field. You can then include the
grouping field in the query's field list and use that in the
report's sorting and grouping.
 
Back
Top