Demographic Query

[Swi]

I have a table with the following information.

gender, age, hh income, # kids, and home value

I want to find the most common to least common demographic based on all the info. What is the best way to accomplish this?

Thanks.

Swi

 

[JBinQLD]

Mate, begin by establishing some demographic ranges. m/f and age are easy, but hh income and home value will almost certainly need ranges

Once you have these in place, query piece by piece until you have your answer.

 

[Swi]

Thanks for the tip.

Swi