Access Microsoft Access Report

[furqan_q8]

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.

 

[furqan_q8]

Thanks guys

I have done it my own way!!!

 

[Anon_F]

Thanks guys

I have done it my own way!!!

Why thank you for thanking us, what a nice person you are.
You have a nice day now & seasonal greetings to you as well.