Hello - I am pretty new to Access 2007. So far I have been able to do ok, but I have this one part of my database that is really giving me a hard time.
We collect demographic information on the clients we serve (Age, Race/Ethnicity, Gender, Education Level, and Household Income). The form is multiple choice.
I created a form to collect the information - but I can't figure out how to create a report. Essentially each form completed is one record in my Demographic table. However, I would like to pull out statistics such as X% of families at X School have an income level of X.
I am not sure if the problem is the way the database is set up or if I am going about creating the queries and/or reports the wrong way.. I have uploaded the database. Figured it was probably easier to show everyone rather than try to explain it since I'm a newby...
Thanks for any assistance.
We collect demographic information on the clients we serve (Age, Race/Ethnicity, Gender, Education Level, and Household Income). The form is multiple choice.
I created a form to collect the information - but I can't figure out how to create a report. Essentially each form completed is one record in my Demographic table. However, I would like to pull out statistics such as X% of families at X School have an income level of X.
I am not sure if the problem is the way the database is set up or if I am going about creating the queries and/or reports the wrong way.. I have uploaded the database. Figured it was probably easier to show everyone rather than try to explain it since I'm a newby...
Thanks for any assistance.
