Hi I am working on my 1st project in Access 2007 for a cattery (I am out of work at present so doing this as payment for my cats).
I made a query to calculate number of days from petindate - petoutdate.

I had to change the formula to add a day, this worked in the Booking table but not in the booking form.

How do I update the form :confused:

Thanks

Bill

More info

In the Booking query I Have NoOfDays: DateDiff("d",[PetInDate],[PetOutDate]+1)
This shows the correct num,ber in the Booking Table ie 10
But on the booking form it is showing 9

Please help