I am just looking for a good source of information for the project described below. Any links, tips or info would be appreciated. I just don't want to spend too much time figuring out how to do this.
I am looking to replace what up to this point has been a manually entry process in Excel, to one where I can set up Access and import Excel sheet to render reports.
A little bit about the information I an working with. This information pertains to invoicing and payment for these invoices. The info will be serial number, inv number, Repair Order number, segment number, claim number, last date of labor, date Repair Order opened, date inv was submitted, parts total, labor total, other total, total.
I can export the information I need from two different systems onto Excel sheets. One sheet for the invoicing info and one for the credit info. These two sheets will have the same information on them, but may be under different field names. I will also have to concatenate two fields (RO # and Segment #) in order to get a unique key to join the two tables (I think).
Here is what I hope to accomplish - have a record of all inv's and all credits. Also, run reports that will render the variance between the inv'd and credited labor, parts and other totals. Additionally the elapsed days between the last labor date and the date the invoice was submitted.
I know my way around Access on a basic level, but I know I am going to have trouble with getting the field names to align on both sheets with the information. EX: one sheet may call the ID # PIN and the other may call it SERNO, but they will have matching info in the cells. Also, the maths in Access is something I do not have experience with.
Thanks in advance.