MS ACCESS report using MS ACCESS (See attached)
## Deliverables
(SEE ATTACHMENT)
Looking for an EXCELLENT MS ACCESS developer for this and additional long term projecta of maintaining my present LARGE ENTERPRISE MS ACCESS 2000 DB uses MDB and SQL for the backend.? Uses VB 6.0 DLL code as well.? NO third party controls
PLEASE ATTACH A RESUME (zipped) along with your BID for this project.? I would prefer you NOT submitting the solution with the BID unless you are VERY CONFIDENT that you will be working with me in MS ACCESS projects for the future IN YOUR RESUME Please include your Hrly rate you would like to see for future projects.
HERE IS THE PROJECT.? I describre presently as what I have now and NEW REPORT for what I need done.? there is an attached file with a MS ACCESS 2000 database that hopefully everyone can work with.
PRESENTLY Report named WeeklyHours_R and all related query link back to the Data_TimeCards_T.
PRESENTLY the WeeklyHours_R Sums ALL time and just shows a single total.?
CalculateTotals_T is Proccesssed data from the Data_TimeCards_T already filtered by dates
PunchType's (Field PunchType)
? E =Edited (this is an edited C punch
? C =Computer generated record
? V = Vacation hrs
? H = Holiday Time
? S = Sick Time
? P =Personal Time
NEW REPORT will need to reference back to the Calculatedtotals_T for the additional fields
NEW REPORT should look semiliar to the weeklyhours_R but need additional fields under the date.
NEW REPORT needs to seperate under each date the SUM for RegTime / OverTime / DoubleTime / Vacation / Sick / Personal / Holiday
NEW REPORT Would be for only 7 days like the WeeklyHours_R? ?
Understood that this the NEW REPORT will be MUCH wider but would like to be as compact as possible 5 character fields for the RegTime/Overtime ect... Example: 10.22
IF YOU ARE UNABLE to open the presenty report check References:
? Visual Basic For Applications
? Microsoft Access 11.0 object library (but I think it can be earlier versions as well)
? Microsoft ActiveX Data Objects 2.8 Library
? Microsoft DAO 3.6 Object Library
? OLE Automation