joining two queries to product one document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if you can combine two queries into a report or call two
queries from a single query?
 
yes to both.

You can create a new query that uses other queries (instead of tables) as
it's source.

You could also build multiple reports based on individual queries and then
insert the various reports as subreports into one big report.

Give us specifics and we might be able to give you more details.

Rick B
 
Here is my issue. I have a query that sums sales order item qty's in a date
range and avg sales cost. I have a second query that gives me live detail
such as onhand qty ect.. I'm joining the two queries on item number. My
goal is to have one spreadsheet with all items and show qty totals for the
items that I specify in a date range. I hope this makes since. When I run
the query I only get items that have history in the date range.

Any help would be great.
 
Assuming each [Item] will have *exactly* 1 row in the
qselLiveDetail and each [item] will have *at most* 1 row
in the qselSalesOrderSummary, you need a Left Outer Join
from qselLiveDetail to qselSalesOrderSummary using the
ItemID as the linking Fields.

HTH
Van T. Dinh
MVP (Access)
 
That must be the issue because most items have more than one row. Each item
falls in three different catagories. Is there another way to get the results
I need.

Van T. Dinh said:
Assuming each [Item] will have *exactly* 1 row in the
qselLiveDetail and each [item] will have *at most* 1 row
in the qselSalesOrderSummary, you need a Left Outer Join
from qselLiveDetail to qselSalesOrderSummary using the
ItemID as the linking Fields.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Here is my issue. I have a query that sums sales order item qty's in a date
range and avg sales cost. I have a second query that gives me live detail
such as onhand qty ect.. I'm joining the two queries on item number. My
goal is to have one spreadsheet with all items and show qty totals for the
items that I specify in a date range. I hope this makes since. When I run
the query I only get items that have history in the date range.

Any help would be great.


.
Click to expand...
Click to expand...
 
Post the details of the Tables that involve in the 2 source Queries, the SQL
Strings of these 2 Queries and the SQL String of the final / combine Query.

--
HTH
Van T. Dinh
MVP (Access)


mccloud said:
That must be the issue because most items have more than one row. Each item
falls in three different catagories. Is there another way to get the results
I need.

Van T. Dinh said:
Assuming each [Item] will have *exactly* 1 row in the
qselLiveDetail and each [item] will have *at most* 1 row
in the qselSalesOrderSummary, you need a Left Outer Join
from qselLiveDetail to qselSalesOrderSummary using the
ItemID as the linking Fields.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Here is my issue. I have a query that sums sales order item qty's in a date
range and avg sales cost. I have a second query that gives me live detail
such as onhand qty ect.. I'm joining the two queries on item number. My
goal is to have one spreadsheet with all items and show qty totals for the
items that I specify in a date range. I hope this makes since. When I run
the query I only get items that have history in the date range.

Any help would be great.

:

yes to both.

You can create a new query that uses other queries (instead of tables) as
it's source.

You could also build multiple reports based on individual queries and then
insert the various reports as subreports into one big report.

Give us specifics and we might be able to give you more details.

Rick B



(e-mail address removed)...
Does anyone know if you can combine two queries into a report or call two
queries from a single query?



.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top