Re: CUSTOMISED GROUPING ON REPORT?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 10/01/04 

Date: Thu, 30 Sep 2004 22:25:29 -0500

confused wrote:
>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

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. 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • RE: Parameter query......query!
    ... In the column of the query bring down your date field ... > My end result is a report that will display records for a certain ... > I need to create a parameter query that prompts the user to enter a ...
    (microsoft.public.access.queries)
  • Re: getting the latest 6 record information
    ... alvarjo9 wrote: ... particular query example below based on the date. ... In my report I should only ... display records from Apr 4 to Apr 10. ...
    (microsoft.public.access.queries)
  • Re: query based on date ?
    ... by using parameters in the query: ... <MS ACCESS MVP> ... Basically I want to build a report off of this query, ... and an end date and it will only display records in that range. ...
    (microsoft.public.access.queries)
  • Re: Pls help with form
    ... If you need to display records on ... a Form or Report, or export them, or base a query on them, you can use a ... Select Query; it's rarely necessary to create a new table. ... of all the query make table does not come up in control source for ...
    (microsoft.public.access.forms)
  • query based on date ?
    ... I've got a table and I want to display stuff from the table with this ... query, but I want the query to prompt for a begin date and end date ... Basically I want to build a report off of this query, ... and an end date and it will only display records in that range. ...
    (microsoft.public.access.queries)