combining data from two unrelated tables in a report

G

Guest

I have been asked to produce a report showing sales from all branches of my
Company. I currently have detailed info for my branch sales, and want to keep
this separate from the data from other branches. I have created a separate
table for the other branches to enter date, product, and contract value
(which is the only info I need for the report). How do I write a query that
will combine my data with that in the new table and then output it on a
report. My data is currently held in two tables, tblProducts which contains
the product field, and tblOrders which contains the date and contract value
fields.
 
D

Duane Hookom

Use a union query. Check Help if you have any questions. If Help doesn't
help, come on back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Report with Unrelated data 2
Access Sorting and grouping using multiple tables 0
Query two identical tables without combining 4
Querying Unrelated Tables into One Report 2
Create a report from two unrelated sources 1
Show one report per customer if multiple sales 0
Dynamic report based on Crosstab Query 2
Fields from two Tables on Report. 5

Top