Query leaving out data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains stats on all our employees. Each line contains
data for each employee for a specific Qtr. So some employees have several
lines other only have one line, depending on how long they have worked for
us. I then use four queries to divide the data into four specific queries one
for each of the last four qtrs. Then I have a query that combines the four
queries into one, each line containing a year's worth of data for each
employee. My problem is that the employees who have less than a years worth
of data do not show up in that query. Is there a way to correct this problem.
The end result is a report I give to each employee, and would like to give
one to thoe who have been here less than a years aswell.

Thank you in advance
Jay
 
Sounds a bit long winded. I think you can do this in a single crosstab
query. Have a look at the "Quarterly Orders by Product" example in nWind as
it does the grouping by qtr and the filtering you would need.
 
Back
Top