Make a report with multiple queries

[ychousa]

Hi.
I have several tables which are not related each other.

I made some queries to select values and calculate each of them from the various tables.

But when I try to make a report using query wizard, it gives me an error that tells me to choose only one table or a query.

I guess it's because the tables are not related, but not sure.

How to add multiple queries in a report?

I have a main Inventory table which has fields for 15 different models and count date.
Also I have Transit Inventory table which has the same 15 models as well as shipment date, year, and a yes/no field.
Another one is Sold Out table which needs to be entered manually and should be subtarcted from the total of each model on the main Inventory table.

My report should show the inventory status of each models, soldout for each models, and transit inventory for each models as well as some calculations.

My calculations include total of each models in Inventory table, the same total in Sold Out table, subtotal(subtract soldout from inventory for each models), total of each models in Transit Inventory table, grand total(subtotal+Transit Inventory total).

Adding multiple tables/queries in query design wizard doensn't work in my case.


Thanks for your help.

 

[Trevahaha]

Why aren't these related? It sounds as if they should.


Inventory <--> Models <--> Transit

 

[ychousa]

Well, this is a very simple database without VBA programming. And because of the nature of our business, they don't need to be related. I guess if the tables are related, then I wouldn't have any problem, but currently it doesn't seem logically correct to relate the tables.