combine query results into 1 excel export

[jln via AccessMonster.com]

How can i combine 6 querys into one excel export. The querys have a user
entered pram of [inv #] for all 6 so i would need a way to have the same
number entered into each query. Then have the results exported to one excel
workbook that would have the inv# and date as the file name.

 

[kingston via AccessMonster.com]

Have you tried a Union SQL query? Create a query on one dataset and then
change it from design to SQL view. Add datasets as shown below and export
the resulting union query.

SELECT Fields FROM Table/Query1
UNION SELECT Fields FROM Table/Query2
UNION SELECT Fields FROM Table/Query3...;

How can i combine 6 querys into one excel export. The querys have a user
entered pram of [inv #] for all 6 so i would need a way to have the same
number entered into each query. Then have the results exported to one excel
workbook that would have the inv# and date as the file name.

 

[jln via AccessMonster.com]

The querys are pulling differnt kinds of data im relly looking for a way to
say enter the inv# into a text box and have that value stored and each query
use that value in strwhere for [INV#]. Then have the data exported for each
query into one excel workbook but each to a differnt sheet.

Have you tried a Union SQL query? Create a query on one dataset and then
change it from design to SQL view. Add datasets as shown below and export
the resulting union query.

SELECT Fields FROM Table/Query1
UNION SELECT Fields FROM Table/Query2
UNION SELECT Fields FROM Table/Query3...;

How can i combine 6 querys into one excel export. The querys have a user
entered pram of [inv #] for all 6 so i would need a way to have the same
number entered into each query. Then have the results exported to one excel
workbook that would have the inv# and date as the file name.