Calculating Total Cost

I am currently making a database project for a school assignment.

I have based the project idea on a local hotel, which consits of a diffrent price dependant on the date booked.

So i have set up a table called "prices" which consits of the following fields:

PriceID
RoomID *
Price
Start Date
End Date

the RoomID is the foreign key, as it is linked (one-to-many) with my Room's table, which consists of the following fields:

RoomID *
Room Number
.. (unecessary fields for the problem)

The room ID is also linked to the bookings table (again one-to-many) with the bookings table consisting of:

BookingID
CustomerID
RoomID
Start Date
End Date
... (uneccessary fields)


what i am hoping to do is (i assume) make a query that will calculate the cost the customer has to pay. So it will look at the start and end date booked in the bookings table and comapre it to the dates in prices table, and find out the cost from this....

any help on going about this would be greatly appreciated, and i hope i have supplied sufficient information (i'll try attach a graphical image of the relationships if that is helpful?)

thanks

michael