Days Count

M

Meme N Jacko

Any help will be appreciated on this one. I have a database that tracks
equipment rentals, the billing for the equipment is done monthly and is
based on the number of days the resident had the equipment. My problem is
that the # of days count is manual and i am having trouble creating a
formula to count the number of days the equipment was out for a month. The
database tracks rental date and return date.
 
N

NetworkTrade

assuming you have an unbound field on the form named DaysOut; what happens
when you try this:
me.DaysOut=me.RentalDate - me.ReturnDate

you might have to throw in a +1 to that if rentalDate and ReturnDate are the
same day to avoid 0 values....
 
J

Jeff Boyce

"How" depends on "what".

What data are you recording?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top