Group by?

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

Guest

I have multiple plan IDs and and totals for each Plan ID. I want to total up
all the amounts (see below) for each plan. I dont want to show Plan ID 0001 a
thousand times in a column just one time then it moves onto the next with a
total in each column for each plan ID. How do I do this in a report or query?
Is this a group by type of arrangement? Where and how do I start?

Example:

Plan ID Unit amt Prod amt Eff Amt
0001 3,000.00 435.00 100.01
0002 509.01 95.99 343.00
0003 3,454.98 234.88 123.88 etc
 
TKM said:
I have multiple plan IDs and and totals for each Plan ID. I want to total
up
all the amounts (see below) for each plan. I dont want to show Plan ID
0001 a
thousand times in a column just one time then it moves onto the next with
a
total in each column for each plan ID. How do I do this in a report or
query?
Is this a group by type of arrangement? Where and how do I start?

Example:

Plan ID Unit amt Prod amt Eff Amt
0001 3,000.00 435.00 100.01
0002 509.01 95.99 343.00
0003 3,454.98 234.88 123.88 etc
Click to expand...

In the Query Builder, set your Table as the data source, then on the menu,
View | Totals. Set Plan ID as "Group By", and the other columns as Total.
That should give you what you show here (but with slightly different
headings, which you can change, if you wish, using the AS clause in SQL or
the <newname>: option in the Query Builder).

Larry Linson
Microsoft Access MVP
 
Are we talking about the query section or the report section. Totals? data
source view totasl? I know where to get these but the QBE does not have a
totals etc. The only thing I get here is the group by but that is in the QBE.
Are you talking about the report section?
 
MScertified..No kidding. This user group I thought was for users that needed
help if they ran out of options. Your suggestion would be the first thing
ANYONE would do in this case
 
Follow Larry Linson's directions carefully.

Open the query in design mode (QBE)
Select View: Totals from the Menu
In the TOTALs line, change Group By to Sum for the three fields used to get
Unit amt, Prod amt, and Eff Amt

Run the query and see if it returns the desired results. If so, use it as
the source for your report.
 
THANK YOU THANK YOU!

John Spencer said:
Follow Larry Linson's directions carefully.

Open the query in design mode (QBE)
Select View: Totals from the Menu
In the TOTALs line, change Group By to Sum for the three fields used to get
Unit amt, Prod amt, and Eff Amt

Run the query and see if it returns the desired results. If so, use it as
the source for your report.
Click to expand...
 
Back
Top