Hi,
I have a table that details all of the sales information daily for several different restaurants. I used a "Calculated_Tax" field to indicate the amount of sales tax to be collected, the only problem is that in July 2015, our county increased the sales tax percentage. If I updated the field to the new sales tax amount, all of my previous data shows big sales tax shortages.
Can I separate the tables by date, correct the calculated field in each, and then link them so that my queries will pull data from both tables?
Suggestions?
Thank you so much!