Query for Report

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

Re: Query for Report

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.

Re: Query for Report

On Oct 29, 3:08 am, Salad wrote:
> 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