combining data from two unrelated tables in a report

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Use a union query. Check Help if you have any questions. If Help doesn't
help, come on back.
 
Back
Top