Hi there!
Can any one help me on one issue regarding Microsoft Access 2003 in Generating Report.
This database is created for maintaining the vehicle issuance record.
The issuance Form contains fields
Veh-ID, Plate No, User_Name, Issuance_Date, Return_Date, Status, #of days Used & Remarks
In case of generating the summary report of vehicle issuance record i am not able to obtained the complete result for "#of days used" when there is value of "Return_Date" is blank due to some vehicles are still in use.
The matter is that i want to get the complete report up to current date instead of putting for all vehicles the "Return_Date".
Find the attached for sample.
Please Help
Thank you.
Can any one help me on one issue regarding Microsoft Access 2003 in Generating Report.
This database is created for maintaining the vehicle issuance record.
The issuance Form contains fields
Veh-ID, Plate No, User_Name, Issuance_Date, Return_Date, Status, #of days Used & Remarks
In case of generating the summary report of vehicle issuance record i am not able to obtained the complete result for "#of days used" when there is value of "Return_Date" is blank due to some vehicles are still in use.
The matter is that i want to get the complete report up to current date instead of putting for all vehicles the "Return_Date".
Find the attached for sample.
Please Help
Thank you.
