Data from multiple tables
Posted: Tue Feb 01, 2011 9:35 pm
Hi____I am trying to produce a single report showing all the adverts booked within a particular period. The problem is, there are different types of adverts each in a separate table! I know how to do separate reports for each with joins to the customer table, staff table etc, but I can^t see how to do 1 report to include all advert types. ____In the past I have written code to export the data to a temporary table which is a pain, especially due to problems if more than one person runs it at a time. If this is the only option, if I export the data to an access table on the user^s C drive as the master table, can I then set up joins to the sql tables on the server? I normally only use 1 or the other in a report.____Thanks