Migrating from an application that is using Excel Macros to manipulate and join data to MS Access.
I will be importing daily labor data into a table and all the data is there except for the Managers Pay.
I have a second table that has the pay rate. and the date the pay rates take effect.
Is it possible to have an update query to find the Manager & pay rate for the date listed in the Labor Data table?
The dates will probably have to be in ranges.. like at 1/1/2016 it was increased to $20.00/hr, and then on 1.1.2017 it was increased to $21.00/hr
Is this possible, or am I better doing this in excel and then import everything into access?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.