how to count records you want

[~marie~]

I need your help. I know how to count records/items in a report but my problem is that I only want to count those records/items I want. Like for example, “Civil Status” field, I want to count how many are married, single, and separated in a report. Please help me and teach me how. Thank you very much!

 

[~marie~]

thanks

Thanks a lot Pat Hartman! You're great

 

[~marie~]

need help again

Ahm what about in the "Age" field.. I want to count how many are young(21 below), middle aged(22-45), and old(46above).. How am I going to do it in a report? I need your help again.

Thanks

 

[ColinEssex]

Base the calculation on the Date-of-Birth. You shouldn't store the age in the database anyway.

A search would have revealed this function that calculates AgeGroups using the DOB.

http://www.access-programmers.co.uk/forums/showthread.php?t=99649&highlight=agegrp

Col

 

[~marie~]

anyone, can tell me step by step how to do it? im having problem with counting. dont know how to call the function via query =S