Est. Budget: $250.00
this project entails importing excel files into access database and creating queries to export to excel file.
in excel there are:
a Master file
a weekly Scan Based Transaction file
both files need to be uploaded to access
a calculated query needs to be made between the two files to generate:
a BILL file
an ORDER file
these two files are to be exported to excel
once exported the files are updated to an access history file.
various queries need ...