A
antmorano
Good Evening Everyone:
I am trying to logically think about what I want to do, but I can't
get it to work correctly. I have a multitude of queries that list
retiree information. The only thing calculated in the queries are the
ages of both the retirees and spouses. I need to generate a report
that only gives me the totals for each retiree plan. I don't need to
know information or anything just totals. For example under the
Health & Welfare Fund: Plans (I-IV) there are ) people but for Plan V
there are 11 and for Plan VI there are 12. Then I would like a Grand
Total for H&W to show 23. Does anyone know of a way that I can do
this. I need to work a lot of numbers just on the total number of
records there are in a query. I read some postings about the sum
totals but you need to calculate that in a predetermined columned...
i.e. last name. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern
I am trying to logically think about what I want to do, but I can't
get it to work correctly. I have a multitude of queries that list
retiree information. The only thing calculated in the queries are the
ages of both the retirees and spouses. I need to generate a report
that only gives me the totals for each retiree plan. I don't need to
know information or anything just totals. For example under the
Health & Welfare Fund: Plans (I-IV) there are ) people but for Plan V
there are 11 and for Plan VI there are 12. Then I would like a Grand
Total for H&W to show 23. Does anyone know of a way that I can do
this. I need to work a lot of numbers just on the total number of
records there are in a query. I read some postings about the sum
totals but you need to calculate that in a predetermined columned...
i.e. last name. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern