adding two fields

[ejacks]

I work with a summer camp and need to know how many campers are coming per
week. I had a query that worked last year, but it will not work now, it was
linked to two tables; campers - registered and week table.
I have two columns week and camper type. What expression can I type to make
these add to show me the total for each week.

Thank you,
ejacks

 

[John Vinson]

I work with a summer camp and need to know how many campers are coming per
week. I had a query that worked last year, but it will not work now, it was
linked to two tables; campers - registered and week table.
I have two columns week and camper type. What expression can I type to make
these add to show me the total for each week.

Create a Totals query based on your table - click the Greek Sigma icon
(looks like a sideways M). Add the Week and Camper Type field, and the
primary key of the Campers table; leave the default Group By on the
Week and Camper Type, and change it to Count on the ID field. Or if
you want to lump camper types together, just leave that field out of
the query.

If you have Week 4 in the table referring to campers in 2003 and also
other campers in 2004, you may be in trouble unless you also have a
date or year field identifying which year's "Week 4" you mean!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Anonymous]

We actually learned this in class a couple of weeks ago. You said you have
two columns (week and campers type) in your query. Click on the sigma symbol
on the menu bar, and a new row labeled Total: will appear. Click on the
Group by field under the Camper type column and choose count. This will then
count the number of campers per week. I hope this helps...