I have an access 2000 table with the following schema:
noteid, auto increment
techid1, integer
techid2, integer
techid3, integer
vminutes, integer (the minutes the tech spend at clients place)
notes_d, date (full date time the tech left to go to the client)
notes_dback, date (full date time the tech came back from client place)
The 3 techid's are related with the techies table in which there are the technicians data, like the techname with the tech's name.
I need to create an ADO datareport, that will return a report for a given time period, and a given tech with all the visits the tech did in the specified period and the summary of the HOURS he spend, to calculate his/her salary.
Any help?
noteid, auto increment
techid1, integer
techid2, integer
techid3, integer
vminutes, integer (the minutes the tech spend at clients place)
notes_d, date (full date time the tech left to go to the client)
notes_dback, date (full date time the tech came back from client place)
The 3 techid's are related with the techies table in which there are the technicians data, like the techname with the tech's name.
I need to create an ADO datareport, that will return a report for a given time period, and a given tech with all the visits the tech did in the specified period and the summary of the HOURS he spend, to calculate his/her salary.
Any help?