Demographic Tracking

[leetx]

Hello - I'm fairly new to Access and I'm stuck on how to structure my demographic table.

I currently have one table for demographics that tracks the following:

Racial Background
Gender
Age Range
Household Income
Education Level

For all categories except Racial Background, there is only one answer. Our clients often select more than one race and I'm not sure how to capture that. Originally I had a drop down box on the Form that would allow more than one race to be selected, however I found it difficult to pull any meaningful reports. I now have it set up so that only one race can be selected, but that is not very accurate either.

Does anyone have some suggestions or work arounds? I would like my reporting to be as accurate as possible based on the clients' response.

Thanks!

[ConneXionLost]

How many racial backgrounds are you trying to identify?

[leetx]

There are only six. I originally had an option for "Other" and a text box below the drop down to data enter anything else selected.. But again, difficult to group in reports...

[ConneXionLost]

As long as the number isn't too large, (six should be fine), then you could opt to forego the "normalized" approach and add a field to your table for each "racial Background". This will allow you the option of easily configuring your entry form to capture "multiple" choices in your table as "Yes" or "No" for each background.