G
Guest
hello
I have a table with a feild named "Ethnic Group" which has a pull down menu
with various choices (ie. Latino, Caucasion). Im trying to create a query (in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50 Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50% Caucasion)
Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)
I have a table with a feild named "Ethnic Group" which has a pull down menu
with various choices (ie. Latino, Caucasion). Im trying to create a query (in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50 Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50% Caucasion)
Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)