Need help adding fields in a query

  • Thread starter Thread starter Maggie
  • Start date Start date
M

Maggie

Hi there, I have searched everywhere and am not able to
find the answer to my issue. I have a table that contains
total counts of adults and youth in each association. I
have queries that pull out each association's data. What
in want to do is include seperate totals of adults and
youth. I cannot figure out how to do this. The sum only
repeats the figures that are there in each colum. Can it
be done in a query or only in a report as a runsum?

Any Takers?

Thanks in advance
 
Please take the time to type in a few sample records with table and field
names. Then add how you want your results displayed.
 
Hi Duane,
tblTroops2004
Troop Girls Adults MeetingTime Day Loaction
123 5 4 6:30 Tues 123 Elm
456 9 7 6:00 Sat 456 Elm
789 15 3 5:45 Mon 798 Elm

I would like to have a colum at the end of the query with
total girls 29 total adults 14. Right now there are 189
populated records in the table.

Thanks
 
You can do this in a report where your totals are Sum([Girls]) in the report
footer.
 
Thank you.

So does this mean that it is not at all possible to
perform the procedure within a query?

M~
-----Original Message-----
You can do this in a report where your totals are Sum ([Girls]) in the report
footer.

--
Duane Hookom
MS Access MVP


Hi Duane,
tblTroops2004
Troop Girls Adults MeetingTime Day Loaction
123 5 4 6:30 Tues 123 Elm
456 9 7 6:00 Sat 456 Elm
789 15 3 5:45 Mon 798 Elm

I would like to have a colum at the end of the query with
total girls 29 total adults 14. Right now there are 189
populated records in the table.

Thanks with
table and field
Click to expand...


.
Click to expand...
 
You can show details and summary data in a query by creating a separate
totals query and then joining them together using a UNION query.

--
Duane Hookom
MS Access MVP


Maggie said:
Thank you.

So does this mean that it is not at all possible to
perform the procedure within a query?

M~
-----Original Message-----
You can do this in a report where your totals are Sum ([Girls]) in the report
footer.

--
Duane Hookom
MS Access MVP


Hi Duane,
tblTroops2004
Troop Girls Adults MeetingTime Day Loaction
123 5 4 6:30 Tues 123 Elm
456 9 7 6:00 Sat 456 Elm
789 15 3 5:45 Mon 798 Elm

I would like to have a colum at the end of the query with
total girls 29 total adults 14. Right now there are 189
populated records in the table.

Thanks
-----Original Message-----
Please take the time to type in a few sample records with
table and field
names. Then add how you want your results displayed.

--
Duane Hookom
MS Access MVP


message
Hi there, I have searched everywhere and am not able to
find the answer to my issue. I have a table that
contains
total counts of adults and youth in each association. I
have queries that pull out each association's data.
What
in want to do is include seperate totals of adults and
youth. I cannot figure out how to do this. The sum
only
repeats the figures that are there in each colum. Can it
be done in a query or only in a report as a runsum?

Any Takers?

Thanks in advance


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top