Currently I have created a new database with multiple linked tables. These are all individual csv files with identical headers.
Here's the files:
2013-jan-web.csv
2013-jan-retail.csv
2013-feb-web.csv
2013-feb-retail.csv
this continues for each month. Each day I export an update from our POS system that includes yesterdays sales. This just overwrites the current month 2013-sept-web.csv & 2013-sept-retail.csv.
The files do not have exactly the same order of fields, but the field names are identical. The newer months have some additional fields added, so field order does not line up. All fields needed for this query are present in all months.
GOAL:
Create a query that is linked to all months and will refresh each time I run it, which is daily. I will only be pulling 8 of 25 fields for the query. Date, Amount, ShippingTotal, SKU, State, DiscountAmount, Coupon, NETRevenue
I'd like to be able to see daily sales, monthly sales and then I'll be setting up YoY monthly reports.
Any suggestions would be greatly appreciated!!!