Return all data, even null in query

  • Thread starter Thread starter Sean G.
  • Start date Start date
S

Sean G.

Hello,
I'm trying to setup a query for a paid time off report, our
work code for PTO is 500, so i query everything that
matches 500 in a certain time period and that works great.
However, on the report i want to show how many hours they
have minus what they have used and what the balance is.
The problem is if they do not have any PTO in the time
period i specify they do not show up on the query. Should
i make two queries?

Any help would be greatly appreciated.

-Sean
 
An outer join from the Codes lookup table typically solves this problem. If
you don't have a codes table, then make it, and then make the outer join.
 
Back
Top