Client is asking for analysis of data.
Have numerous fields holding said data, most contain drop downs, some are yes/no
I start with 1 qry grabbing all client ID's with all the populated fields.
CLient is asking for a totla(e.g. languages being spoken, as well as nbr of males/females speaking said language)
other examples: geographic data, etc
I already have count queries running for each field in the table for daily use, but, client needs all together to show %....what pct race, religion...all that fun stuff.
What is best way to show this.
Tried doing a crosstab, but, seems really messy with so many fields.
Union query? dump all info into excel and let them sort it out