counting entries using a form

[rydell]

hi all,
just found this site today, looks like it could be very useful!
alright here is my problem. i have a table that stores application data for students that apply to our program. what i need to do is create something to break this info down and compare it.

so i'll pick the easiest one first. i want to count the number of students who applied (broken down by male and female). now i know i could do this with a query and a report, but by the time i get done with all the info i have i'd have about 50 different queries that only do one count each. so i want to avoid this.

so my question is can i do this analysis on a form using textboxes and expressions or will i have to go to visual basic and write functions?

any help, insite, or a different direction completely would be greatly appriciated

 

[Howlsta]

Yes you can do it on a form and it probably isn't too complicated. For starters you could have a combo box to select male, female or both. You could add other combo boxes for other criteria that you do or don't want to check for.

The combo box selection can be gathered in the query criteria. You could display the results in a subform.

Good luck.

Rich

 

[rydell]

ok i will go with the form idea but i need to keep it pretty simple (i.e. just one form), but in my first post i dont think i explained what i was having trouble with. so i'll try another way.

i want to use text boxes to count the number of male students and female students, but i dont know how to make the code work. i have been trying to use expressions but all i can come up with is the total number of students that applied. how do i filter (using an expression, not a form filter) the male students from the female students and display the total number of each in seperate text boxes on the same form?

did that make a little more sense?