By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,855 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,855 IT Pros & Developers. It's quick & easy.

Query for Report

P: n/a
I am helping a non-profit track their elder clients and care given to
the clients.

The organization would like a report that shows various info on ALL
clients, such as:
# in each town,
# and Percent Male, Female, Smoker,
# in age range
# that use wheelchair or walker.

I have the information on tblClients, and the "condition" (wheelchair
or walker) on a different table (tblIntakeConditions) with a
relationship table (trelIntakeConditions) that shows the clientkey and
the condition key (there can be multiple conditions per client).

I don't know how to write the query or report to get this info for the
organization.

Can anyone help?

Right now I have tried a query for each piece of info, and I am not
sure how to get it all on one report.

I can post queries, table design - whatever is needed...HELP!!!!
thanks -
sara

Oct 28 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
sara wrote:
I am helping a non-profit track their elder clients and care given to
the clients.

The organization would like a report that shows various info on ALL
clients, such as:
# in each town,
# and Percent Male, Female, Smoker,
# in age range
# that use wheelchair or walker.

I have the information on tblClients, and the "condition" (wheelchair
or walker) on a different table (tblIntakeConditions) with a
relationship table (trelIntakeConditions) that shows the clientkey and
the condition key (there can be multiple conditions per client).

I don't know how to write the query or report to get this info for the
organization.

Can anyone help?

Right now I have tried a query for each piece of info, and I am not
sure how to get it all on one report.

I can post queries, table design - whatever is needed...HELP!!!!
thanks -
sara
I can provide some advice.

# in each town,
Create a query. Drag Town in it two time. Create a Totals query (use
menu item Query if needed)

# and Percent Male, Female, Smoker,
Create a query. Drag a field down, make it a totals query, and set the
field to Count. This will give you an overall count for calcing
percentages.

Create a totals query. Drag Sex two times and Smoker. I might do
something like
MaleCnt : IIF(Sex = "M",1,0)
and Sum it. Do the same for Female and Smoker.

# in age range
'Don't know.

# that use wheelchair or walker.
Do the same as the one for Sex.

I have no idea what the key is in this group. Town? If so, you may
need to create a master query (totals) that groups on town. You'd also
add it to those other queries.

Then you open up the Town query and add the other queries you created.
You can then set the link lines between the queries. You may want to
make the links All records in Town and matching recs in the other table.

This is just general stuff because I don't know what the key component is.
Oct 29 '07 #2

P: n/a
On Oct 29, 3:08 am, Salad <o...@vinegar.comwrote:
sara wrote:
I am helping a non-profit track their elder clients and care given to
the clients.
The organization would like a report that shows various info on ALL
clients, such as:
# in each town,
# and Percent Male, Female, Smoker,
# in age range
# that use wheelchair or walker.
I have the information on tblClients, and the "condition" (wheelchair
or walker) on a different table (tblIntakeConditions) with a
relationship table (trelIntakeConditions) that shows the clientkey and
the condition key (there can be multiple conditions per client).
I don't know how to write the query or report to get this info for the
organization.
Can anyone help?
Right now I have tried a query for each piece of info, and I am not
sure how to get it all on one report.
I can post queries, table design - whatever is needed...HELP!!!!
thanks -
sara

I can provide some advice.

# in each town,
Create a query. Drag Town in it two time. Create a Totals query (use
menu item Query if needed)

# and Percent Male, Female, Smoker,
Create a query. Drag a field down, make it a totals query, and set the
field to Count. This will give you an overall count for calcing
percentages.

Create a totals query. Drag Sex two times and Smoker. I might do
something like
MaleCnt : IIF(Sex = "M",1,0)
and Sum it. Do the same for Female and Smoker.

# in age range
'Don't know.

# that use wheelchair or walker.
Do the same as the one for Sex.

I have no idea what the key is in this group. Town? If so, you may
need to create a master query (totals) that groups on town. You'd also
add it to those other queries.

Then you open up the Town query and add the other queries you created.
You can then set the link lines between the queries. You may want to
make the links All records in Town and matching recs in the other table.

This is just general stuff because I don't know what the key component is.- Hide quoted text -

- Show quoted text -
Thanks, Salad.

I'm working on this....So far I have about 1/2 done. Will post back
if I struggle more - but I *think* I'm getting there.

Sara

Oct 29 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.