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
any suggestions?
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
any suggestions?