Summing Rows?

  • Thread starter Thread starter ielmrani via AccessMonster.com
  • Start date Start date
I

ielmrani via AccessMonster.com

Hi,
Is it possible to sum rows from the same table?
I have this table:

PlanID PLAN Assests BP Fee Amount
BP B
BRIMP Birthright $499 0 0.00 $6.15
BRINQ Birthright Israel $515 40 515.35 $3,146.50 INVOICE
CNSCB Collier Neurologic $687 0 0.00 $18.45
CNSSS Collier Neurologic $3,174 40 317 $4,827.94 INVOICE
PACB Peckar & Abramson $3,401 $34.85
PAPC Peckar & Abramson $11,576 40 1157 $16,662.65 INVOICE
PAPC2 Peckar & Abramson $1,718 $19.68

I would like to get this result:

PlanID PLAN Assests BP Fee Amount
BP B
BRINQ Birthright Israel $1014 40 515.35 $3,152.65 INVOICE
CNSSS Collier Neurologic $3861 40 317 $4,846.39 INVOICE
PAPC Peckar & Abramson $16,695 40 1157 $16,717.18 INVOICE

I am trying to add sum assets, BP, Fee Amount and get the max of the others.
Thanks so much in advance.
Ismail
 
You will need to create a Totals Query. In the query, you need to make a
variable that will designate the grouping by plan. For instance, if you
create a new field in your query for the 1st column
PlanGroup: Left([PlanID],2)

Then on your totals line you would group by the Plan Group and sum or max
for the other fields.

Hope this helps.
Jackie
 
thank you Jackie. It worked.

Jackie said:
You will need to create a Totals Query. In the query, you need to make a
variable that will designate the grouping by plan. For instance, if you
create a new field in your query for the 1st column
PlanGroup: Left([PlanID],2)

Then on your totals line you would group by the Plan Group and sum or max
for the other fields.

Hope this helps.
Jackie
Hi,
Is it possible to sum rows from the same table?
Click to expand...
[quoted text clipped - 21 lines]
Thanks so much in advance.
Ismail
Click to expand...
Click to expand...
 
Back
Top