Calculating Number of Days between two dates

[Help]

Hello,

I am new to Access and dont know any thing about VBA. I need to do a report to calculate the reimbursement amount for user based on the dates in the database.I believe that I need to write Function to calculate the number of days between two dates

There are few business rules to follow before we calculate reimbursement amount. It has to with date and time. I have two fileds in my table. Both have datatype Date/time. One stores the date in short format and the other time as long time.

I tried to attach the business rule file as jpeg file after scaning it but its size is too big. The file can be seen by clicking the link below

http://www22.brinkster.com/sqlali/T.jpg

I would higly appreciate if some one help me to do this. Thanks in advance

Saima

 

[Mile-O]

It would be smarter to have one field to stre bothe the date and the time. You may want to look up the DateDiff() function in the help files as this will tell you the difference between dates and times in the unit of your choosing.

Finally, I've answered questions on bank holidays numerous times before. Try doing a search on my name and holidays - you'll no doubt get loads of results.

 

[Rich]

Finally, I've answered questions on bank holidays numerous times before.

Don't you get a day off then like the rest of us?