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.
.

Relevant Pages

  • Re: Formatting/Coding a Report...
    ... Then you could export the query a an Excel ... or you could set up a report with that same ... > whether they are new or existing clients. ... > totals column on the right side of the report for individual programs and ...
    (microsoft.public.access.reports)
  • Re: Summarizing records in one table that match a different table
    ... > the report. ... > using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)
  • Re: Summarizing records in one table that match a different table
    ... > the report. ... > using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)
  • Table Linking and Queries??
    ... I have one table for clients and in this table I have StateID, ... How do I have to link them in the query? ... In my report I want to show the telephone codes which relate to the state ...
    (microsoft.public.access.gettingstarted)
  • Re: Help!! Totalling Results from "Count" function
    ... create a totals query that is similar to your main report's query. ... Then create a report based on your query. ... >> MS Access MVP ...
    (microsoft.public.access.reports)