creating report from 2 queries

[kim40]

I need to create monthly quarterly and yearly reports. I have 2 queries one with the quantity of goods imported and the other the amount of revenue collected.
the quantity report runs on the day it arrives into the country, while the revenue query runs on the day the goods were paid. My boss needs to see reports for both the quantity and the revenue. is there a way that I can combine both set of data to make one report.

 

[plog]

This is more of a query question than a report question. You cannot have 2 queries feed one report (you can have sub reports, but it sounds like you want all data on one line, not in a different section).

What you want to do is create a new query and somehow link your 2 existing queries (possibly by product number and what ever relevant fields relate the records between the two) and then use that new query to feed your report.

If you can provide sample data from your 2 queries I can help more specifically.

 

[kim40]

how do I send the files and can I send the spread sheet with the original data?

 

[boblarson]

You can create a report for each and then put them both into a blank report and not link them. That would create a single report but with both reports (I do it for a few of ours at work too).

 

[plog]

For sample data, just type it in here.

TableA
productid, qty, importdate
1, 500, 1/1/2012
2, 32, 3/3/2012
1, 600, 2/1/2012

TableB
productid, revenue, revdate
1, 1250.75, 3/1/2012
2, 62.00, 9/17/2012

 

[kim40]

Arrival Date Fuel Type quantity Year Month Quarter
07-Sep-12 Gas Oil 500 2012 9 3
02-Sep-12 Mogas 300 2012 9 3
06-Sep-12 Jet A.1 200 2012 9 3
08-Sep-12 Other 50 2012 9 3
03-Sep-12 Jet A.1 500 2012 9 3
04-Sep-12 Jet A.1 20 2012 9 3
02-Sep-12 Mogas 10 2012 9 3
04-Sep-12 Other 5 2012 9 3
12-Sep-12 Other 3 2012 9 3

The Revenue query is the same except the arrival date is the Date Paid and quantity is replaced by Revenue

 

[plog]

My fault I should have been more specific. Post sample data from the first query, the second query and what you want the final product to look like based on the sample data you provide.

 

[plog]

Seriously, make it easy for me. You've got 5 tables in there and 6 queries, I have no idea how this is suppose to work together and don't really want to wade through it all to figure it out myself.

I see the import table, that leaves 4 tables that I have no idea what they do. Just post sample starting data and what you want the output to be based on that sample starting data.

 

[kim40]

Super moderator I have created the 2 reports how do I put both into a blank report. I also read the link that you sent thanks

 

[plog]

I'm done. As in I'm not going to try and help you any further. Possibly someone else will.

The import table (finished report) is not based on the data you have in that database. I tried a few times for you to post sample data along with what the finished product would look like based on the sample data. You've posted a finished product unrelated to the source data you have provided.