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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate time 1
Combine Duplicates in Query 0
Returning null values 4
Query criteria - exclude data and return all records if null 3
"Invalid use of Null" in query 3
Showig differences in Month to Month data from data in the same ta 8
Time as a Value in Queries 2
Stacked Column Chart 3

Back
Top