I got these 2 queries that I am working on and I need to join them both together. Here is my delema.
1. First Query has a total of 13 Records cause it has a certain criteria in it that says select the record with this type of deduction code.
2. Second Query has the main database and has everyone in the company in that database.
3. I need to join the queries together and if the employee does not have that deduction code it should give them a "0" in the total field instead of not selecting them.
4. I am putting the totals and the rest of the data on a Report.
Does this make sense?
John-
1. First Query has a total of 13 Records cause it has a certain criteria in it that says select the record with this type of deduction code.
2. Second Query has the main database and has everyone in the company in that database.
3. I need to join the queries together and if the employee does not have that deduction code it should give them a "0" in the total field instead of not selecting them.
4. I am putting the totals and the rest of the data on a Report.
Does this make sense?
John-
