Problem with Combining two tables in report

[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]

Have you tried a Totals query?

This may give you the result you're looking for.

Totals queries are turned on via the Sigma button on the toolbar, or in the Query menu I believe. You can choose different options, such as Group By, Sum, etc. If you include both tables in your query and then choose the appropriate total mechanism, you may be able to get the end result you desire.

If you need more help, post back. I'm not sure I understood your question correctly.

David R

 

[bri822]

Thank you for the information, but that was not exactly what I was looking for. I will see if I can explain it better.

I need to make a report that shows mailing information for each day. And I have two tables with mailing information. And since some jobs don't mail all in one day, I have two tables. Table 1- it contains job number, quantity and date. If a job mails in more than one day, it produces a set of records with the same job number and an entry for each date to mail. My second table contains information for all the jobs. It has job number, an ending date, ending quantity, and other information (ie. job status).

My report needs to show how much we need to mail for each day. So if it mails all in one day, I have no problem, all the information is in the second table. But it gets tricky when it mails on multiple days. Because then I have to pull from the first table. Ex. If it mails over 5 days, I need to show the spread, not just the ending date and ending quantity.

This would not be so bad if the report only needed quantity. But for the report, I need to show job number, quantity and job statues for each day. My problem is how do I make a report from my first table and add in the corresponding missing information form the second table. This is a very complicated problem and hard to explain in simple terms, so if any one can help but is confused, please let me know and I will try my best to clarify. Thank you!

Brian