counting summary

[goju]

hi
i have a number of query's (Current memberships, out of date memberships etc) all via a certain area/town.

i am trying to find out total figures (how many members how many non members, how many in certain area/town. these need to be updated continuoulsy.

do not no how to approach i ahve looked at the sigma sign and played with no luck.

should i be looking at another query for totaling or un update qurey, sorry very lost, would like this information also displayed on my record form.

searched all weekend with no luck any ideas.

 

[neileg]

You havn't give us much to go on as to why you couldn't create a totals query!

You might need to use the DCount() function if you want to display these counts in a form.

 

[goju]

sorry neil not sure how to go aboyt the totoals query, its probably the ansewer but i am totally in the dark.

is just a case of creating a new "totals query" pick the fields i want to add up etc