I'm trying to create a database for a Cattery business.

One thing I'd like to include is a query that calculates how long a cat has been staying at the cattery and then calculating the amount owed by the owner.

I don't have a cost field in any of my tables, so I need to create this on every run of the query.

So for example

A Cat resides in the cattery from the 22nd of Feb to the 28th of Feb. So 6 days (not including the day the cat is brought into the cattery) at a cost of 4.95 a day equals 29.7

Heres what I have so far
http://www.tdh1987.co.uk/pics/query.JPG

Bear in mind I'm from the UK, so the date field is in a different format to yours.

Any help will be greatly appreciated.

Look up the DateDiff Function

Bear in mind I'm from the UK, so the date field is in a different format to yours.This is a UK based forum! Lots of us are from the UK. Fortunately, we also have lots of knowledgable, helpful contributors from around the world, too.

Oh, silly me.