troubleshooting Question
Access Database
asked on
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?
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?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
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.