Printing "unused" codes

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

Guest

I have created a weekly summary report that totals the number of records per
job code and their percentages in relation to the total number of records (no
problem here) However, if a job code is not used a record is not generated
for that particluar job code. This "unused" job code will not show in the
summary report! My boss wants to see all the job codes regardless if they
have a record or not. For example:

Job Code Number of jobs
10 12
20 0 'This job code will not be printed in the
Summary report!
30 10
 
Ricoy-Chicago said:
I have created a weekly summary report that totals the number of records per
job code and their percentages in relation to the total number of records (no
problem here) However, if a job code is not used a record is not generated
for that particluar job code. This "unused" job code will not show in the
summary report! My boss wants to see all the job codes regardless if they
have a record or not. For example:

Job Code Number of jobs
10 12
20 0 'This job code will not be printed in the
Summary report!
30 10
Click to expand...


Change the report's Record Source to a query that uses an
outer join from the table of codes to the table that you're
currently using.
 
Back
Top