473,574 Members | 2,727 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 (tblIntakeCondi tions) with a
relationship table (trelIntakeCond itions) 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
2 1963
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 (tblIntakeCondi tions) with a
relationship table (trelIntakeCond itions) 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
On Oct 29, 3:08 am, Salad <o...@vinegar.c omwrote:
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 (tblIntakeCondi tions) with a
relationship table (trelIntakeCond itions) 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
7559
by: Donna Sabol | last post by:
First, I should start by saying I am creating a database to be used by some very impatient, non-computer literate people. It needs to be seameless in it's operation from their point of view. I want them to do as little as possible when they run their reports. I have a crosstab query that displays usage of items for each month. It looks...
4
1710
by: Richard Hollenbeck | last post by:
The following query takes about one second to execute with less than 1,000 records, but the report that's based on it takes from 15-30 seconds to format and display. That's frustrating for both me and the end user. The report is a student grades sheet showing the results of all his/her activities and final grade for all students in any...
15
4390
by: Richard Hollenbeck | last post by:
I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows of students and columns of activities and the data are the students' scores in each activity. No problem, almost. The problem is that there are...
2
9336
by: amith.srinivas | last post by:
Hi all, From a word macro in VBA, I am trying to create a report in access DB. The report is based on a query with a parameter. I am using Set rpt = Application.CreateReport rpt.RecordSource = <<Query_Name>> Once I create the report, I m trying to create labels to display the Report title in the Report Header section.
5
3509
by: Wired Hosting News | last post by:
I tried to be breif and give a scenario so as not to be overlooked because it was soooo long. Let me give you real world. I am a manufacturer of goods and produce 11 items that are distributed to 1800 stores of a national home improvement chain store. Every week I electronicaly receive an excel spreadsheet "inventory report" with 19,800...
1
2754
by: Rob Woodworth | last post by:
Hi, I'm having serious problems getting my report to work. I need to generate a timesheet report which will contain info for one employee between certain dates (one week's worth of dates). I have a table containing records for each job done, the records contain date, employee name, job done (a code representing the type of job), cost code...
4
3820
by: Jimmy | last post by:
I have a form with a command button on it that is supposed to open up a report and use a query to populate it. DoCmd.OpenReport "rptMailingList", acViewPreview, "qryMailingListChristmas" qryMailingListChristmas sql: SELECT DISTINCTROW tblClients.BillingName, tblClients.AccountType, tblClients.BillingAddress, tblClients.Contact,...
4
9461
by: Simon | last post by:
Dear reader, The syntax for Docmd.OpenReport is: OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) Example The following example prints Sales Report while using the existing query
4
3125
by: lorirobn | last post by:
Hi, I have a report displaying items that are missing from a room. I created 2 queries, the first getting the items IN the room, and the second being an "unmatched" query that references the first query where Item is Null. I use a subreport for the details, and the results display correctly. However, the Report_Details event of the...
6
6850
by: Phil Stanton | last post by:
I am running a query that calls a function used to format addresses depending on the width of a control on a report that shows that address. The same query is used as the RecordSource of lots of similar reports, but all with different sized Address text boxes. For the function to work, the report need to be open in design view, so that the...
0
8066
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8249
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7826
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8106
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6461
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5631
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5305
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3743
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
1066
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.