Newbie question

[leetx]

Hello - I work for a non-profit and we have a database with a table that holds all of the demographic information on each family we serve.

That table is linked to a table of Schools in a one to many relationship. (One school can have multiple demographic records).

In each demographic record we collect age, race, household income, education level and gender of the person filling out the form. All, except the gender option, is a combo box that does not allow for multiple values.

Ultimately I would like to create ONE big report that breaks down all of this information by school and by date. My problem is that Access is grouping each value, so instead of finding out how many people at each school are between the ages of 30 and 39, I can only find out how many people at a particular school are between the ages of 30-39, have a household income of more than $50K, are female, etc.

I would like individual values for race, age, household income, education level, and gender independent of one another for each school.

I want to look at each variable individually in the report. I have attached a sample database with the two tables I'm describing.

Feel free to ask me questions. I am not sure of all the terminology so I'm hoping the example helps explain a little better.

 

[HiTechCoach]

I want to look at each variable individually in the report. I have attached a sample database with the two tables I'm describing.

Welcome to AWF!

Having only two tables and the issues your have with reporting to me raises a is a big red flag for table design issues.

This should be very easy with a properly normalized databases.

I would urge you to correct the database structure to make your reporting very easy.

If you are not going to change the table structure, then you will need to make a lot of queries, one for each statistic you want to calculate. I would probably use a sub report fro each statistic. You may be able to use a UNION query to put all the queries into a single recordset.


Hope this helps ...

 

[accessfever]

I don't think you need to join two table into one table since it seems like you have all data you needed for analysis. I think the way you created for the Select Query is not quite what you needed when I looked at your problem that you said "the Access grouped each value". If you go back to your Select Query and turned off the "Subtotal" or "Group" function, then you should get all individul data instead of grouping data.