RichardPrewitt
IS-IT--Management
Im writing reports in access that are printed from a VB program. Now on one of the reports they want me to take the last completed date which in a field in each record and compare it to today's date to get a "how long has it been since this task was completed last" field on the report. I was wanting to know if I could just code it into Access report or do I have to add another field in the database and code it into VB to generate the field every time they enter a task?
I was in the code of the detail of the access report that I want this done on and made a label box on the report and called it lblLast I then typed in lblLast. and got no usable values to replace the caption of the label with what I want to show up on the report.
Any help would be appreciated
- Richarde
I was in the code of the detail of the access report that I want this done on and made a label box on the report and called it lblLast I then typed in lblLast. and got no usable values to replace the caption of the label with what I want to show up on the report.
Any help would be appreciated
- Richarde