how to select data for calculation

[Erictsang]

Dear Guru

I have a question in selecting data for calculation

I use that for hotel room calculation

Date of stay

1/10 - price : 100
2/10 - price : 120
3/10 - price : 100

Now guest stay from 1- 4 Oct , so i need to calcalate the sum of price based on the period of their stay

How can i do that ?

Eric

 

[CJ_London]

something like

SELECT sum(price) as totalprice
FROM tblRates
WHERE ratedate between [firstdateofstay] and [lastedateofstay]-1

 

[Uncle Gizmo]

DSum?

More Here:-
https://www.access-programmers.co.uk/forums/showthread.php?t=286664

 

[Pat Hartman]

The suggestions offered work as long as there is a price in your price table fore every single day for every single room or room class. Is that what you have? Or, do you have a more generic model where you have a price by day of the week with perhaps unique prices for certain days such as New Year's Eve?

 

[Erictsang]

CJ

Something similar but have to lookup the price with the date

I have two criteria to lookup

a) Hotel
b) date of stay

i am new for Access formula.

If i built a table, for hotel with different date price which , then, Reservation Form can calcualte the total room costs ?

Table for room rate [form]![date] ?? i do not know how?!
Hotel
Date
Price

 

[CJ_London]

As Pat has suggested, you need to know how your data is structured. So are you asking how to structure your data?

If so, you need to describe your business - how it works in the context of the question you are asking