Problem making a report from two seperate tables

[bri822]

I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables.

Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job. Therefore the same job mails on more than one day.

Table 2 - has all jobs, including the total for the jobs that mail on multiple days. It also contains needed information about status of the job and some other information.

Pretty much, I need to combine the information in table 2 with the quanitities and days of table 1. I can't figure out how to go about doing this. But I think I need to some how copy table 1 with some extra information fields that I need for table 2. Then go back in and update the information in this third table if the jobs are the same. And then append the jobs that are one day jobs on the end of the table/query.

I am not sure if anyone can really make sense of this, but I am really stumped. I would really appreciate any information that anyone would have. If I did not explain it well enough, please email me at bri822@yahoo.com and I would be happy to explain it more. Thank you!

Brian

 

[David R]

Please don't post the same thing in multiple forums

RV and I have both answered you in other forums. Choose the one most appropriate to your topic, or if you can't decide, choose General.

Someone will see the question, I promise you. repeating yourself only wastes time (yours, and others'), and annoys the people you're asking help from.