cycling through drop-down boxes

[lxh]

Hi all

I hope you can help. I have to write a query that creates statistics based on a drop down box. for example a drop down box that has higest exam level in it, GCSE, A level, degree, Phd., and a tick box for male or female.

My query needs to return the number of males with "each" type of exam as a percentage of the total number of males. Then similar for females. I have done it for individual exam results, eg males with a degree. But is it possible to 'loop' through each value of the drop down box (and tick box?) automatically and return those statistics.

Latter queries require me to get statistics for all values of one drop down against all values of another drop down. If there is not a way I fear I will have to write them all out long hand - and that could take a while!

Thanks in advance for reading and any suggestions you have.
Lex

 

[dcx693]

I have to write a query that creates statistics based on a drop down box.

It sounds like you're using a form to select each category then run the query.

If you want all combinations, then why not just run the query, but don't base it on the form? Use a totals query and calculate your summary statistics there. You can group on different categories (by exam level, then by sex) and calculate statistics for each group.

 

[lxh]

using forms to produce queries

Thanks dcx693 - I was dooing just that (using forms)! I've chnaged to what you suggest.

Lex