Liveware Publishing Support Forum

Tried to perform all the joins inside Access but when I ran a Make Table query - an error message popped up about too many tables or columns, etc. So I went back into R&R and made all of the joins I needed, it took awhile as the nine other tables were linked to a common field in the master table...

I am using the SQL version and attempting to join 12 tables inside of an Access database. Six tables contain annual revenue data and six contain annual expense data. All 12 tables have a common field (facilityID). My objective is to develop a time series report which can pull in data from each year ...