Days Count

  • Thread starter Thread starter Meme N Jacko
  • Start date Start date
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.
 
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....
 
"How" depends on "what".

What data are you recording?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top