Subreport??

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I have created a database to track time spent on specific jobs. Tables set
with JobNumber (auto number), employee, customer name, etc. Everything
working well. Now, boss wants to add form to enter info for work that
doesn't relate to specific jobs. I set up tables for MiscWorkCodes,
employee, etc Is there a way to bring these two sets of info together based
on employee field? I tried to work a subform (with misc job info) onto a
main form (specific jobs). The problem with this is if an employee only has
work on a misc job (subreport) and nothing on a specific job (main report),
it doesn't show on the report. Is there a way to do this if the main form
has no info for the employee, but the subreport does?
I hope this isn't too confusing!! Any help is greatly appreciated!
Thanks, Pam
 
If there's no relationship between the Specific jobs and the
miscellaneous jobs then a subreport won't work.

What I would do is give misc work a number just like the others but add
a type field to the table that differentiates between the misc work and
the jobs that get a work order (?)

then you can group the report on Employee
Work Orders
Misc Work
 
Back
Top