D
Dan McClelland
It sounds like you are attempting to get a count of
unorphaned data. In other words, how many clients from my
clients table have matching data in my counseling session
table AND my trainee attendee table. Here's a quick and
dirty (yet effective) solution...
Create an aggregate query that gives you a count of
clients who were counselled for the given quarter (the
count function will eliminate the duplicates). Create a
separate query that does the same for clients trained.
Then create a third query, adding the first two queries
into the table/query pane, joined on the client field, and
include the counts or a calculation to sum the counts.
table (which has each clients demographic info). What I
need to do is find out the total # of clients (counseled
and trained) from a quarter. I am trying to develop a
query or a report that will combine this info but I am
having troubles designing it. I want clients,
unduplicated (many may be trained or counseled more than
once a quarter) pulled together so that I have the total
clients that we served for a quarter. When I try to do
it, I end up with only the clients that are listed as both
trained and counseled rather than all of them. Once I can
get a query or a report to list them together, then I need
to use the client information table to pull the
demographics on each client. I do have dates in the
client info table, but I can't use that for the total
clients because many clients may be counseled or trained
while they first became a client 2 years earlier and that
is the date on their intake (client information). If
anyone can help me I would really appreciate it.
Client_Number.
unorphaned data. In other words, how many clients from my
clients table have matching data in my counseling session
table AND my trainee attendee table. Here's a quick and
dirty (yet effective) solution...
Create an aggregate query that gives you a count of
clients who were counselled for the given quarter (the
count function will eliminate the duplicates). Create a
separate query that does the same for clients trained.
Then create a third query, adding the first two queries
into the table/query pane, joined on the client field, and
include the counts or a calculation to sum the counts.
trainee attendee. They are both linked to the client info
table (which has each clients demographic info). What I
need to do is find out the total # of clients (counseled
and trained) from a quarter. I am trying to develop a
query or a report that will combine this info but I am
having troubles designing it. I want clients,
unduplicated (many may be trained or counseled more than
once a quarter) pulled together so that I have the total
clients that we served for a quarter. When I try to do
it, I end up with only the clients that are listed as both
trained and counseled rather than all of them. Once I can
get a query or a report to list them together, then I need
to use the client information table to pull the
demographics on each client. I do have dates in the
client info table, but I can't use that for the total
clients because many clients may be counseled or trained
while they first became a client 2 years earlier and that
is the date on their intake (client information). If
anyone can help me I would really appreciate it.
and what I am trying to bring together are named
Client_Number.