This is a very simple project. I have an Access database which store the employee time spent on each troubleshooting issue. I need to run a query to get all the tickets which were updated by a specific technician for a specify date, and I have to run and format it in excel. The query is going to be SELECT full_name, work_time,category, task_task, wo_number, hours_worked, mileage, parking, description, datestamp FROM Activity Where full_name = “value in the cell for name?? AND datestamp= “value in the desiganated date cell??
Attached is the excel worksheet and the Access Database. Following is the mapping of the fields:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).