H
HeatherD25
Hello,
I am trying to build a query (based on the results of two different queries)
to use as the data for a report.
One query returns a list of all of the projects an individual has worked on
during the year. Some fields from this query are:
EmployeeID
Period
Project
Hours
Another query returns a list of each employee and the total possible hours
they could have worked during the year.
I used to just have the first query run as the source for the report (and
had "total possible hours" as a field in it), but then I realized that I was
excluding any people
that hadn't worked on any specific projects.
How can I create a query that will give me both sets of data... If a person
has worked on a project I don't need to add anything else, but if they don't
then I need a line in the query return that lists their name and something in
"total possible hours" field. All of the other columns would be blank for
this entry.
Is this possible?
Thanks!
Heather
I am trying to build a query (based on the results of two different queries)
to use as the data for a report.
One query returns a list of all of the projects an individual has worked on
during the year. Some fields from this query are:
EmployeeID
Period
Project
Hours
Another query returns a list of each employee and the total possible hours
they could have worked during the year.
I used to just have the first query run as the source for the report (and
had "total possible hours" as a field in it), but then I realized that I was
excluding any people
that hadn't worked on any specific projects.
How can I create a query that will give me both sets of data... If a person
has worked on a project I don't need to add anything else, but if they don't
then I need a line in the query return that lists their name and something in
"total possible hours" field. All of the other columns would be blank for
this entry.
Is this possible?
Thanks!
Heather