Best way to print totals

G

GMan

Thanks so much for the help. I'm getting there!!!

I have a database that tracks 4 pieces of information: Male, Female, High
School, College. I have 4 queries that gives me Male HighSchool, Male
College, Female High School, Female College.

I need to occasionally see the totals for each of these. So I just run each
query and see the total at the bottom.

But how do I combine all of this into a report that simply tells me the
totals for each of these variations, and nothing else??

I suspect I combine all 4 queries into 1 and then just output filtered
information to 4 different bound boxes in my Report. But I need some help on
doing this. All I really need is a counts the totals of:

Male w/ High School
Male w/ College
Female W/ High School
Female W/ College

I am light years of where I was a year ago, but I still am somehwhat
"conceptually deficient" I appreciate this forum where I do alot of
lurking and learning!
 
D

Duane Hookom

If you can't get all of your totals into a single query, I would recommend
using subreports for each query. Place all the subreports into a main report.
 
K

KARL DEWEY

I have a database that tracks 4 pieces of information: Male, Female, High
School, College.
Are these the names of fields in your table? If so then your table design
is wrong.
It should be something like this --
Gender - Male, Female
Education - High School, College
What are you storing in your fields, a count?
Do you have other fields? What are they and what datatype?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top