View Single Post
 
Old 06-11-2014, 12:31 PM
EC37 EC37 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

Another option could be to utilize Pivot Tables.
I used to run queries for a company previously that would return 100,000+ rows of data. Sometimes you have to get creative. Unless there is a true reason behind keeping the tabs for Sales and Inventory separate, you may want to combine the 2 together. Looks like you have similar data contained on both. I would then insert another column, such as, "Type" or something of the sort. Identify the rows accordingly 'sales' vs. 'inventory' data.

Then utilize the Pivot Table function to summarize the data. It presents really well, and is very simple to use. Just have to get the hang of setting up the table itself.

Bob- do you think that is also a viable solution as well?
Reply With Quote