Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago

Novice in need of help with rental rate formula

Greetings: I am a novice that is trying to calculate rental rates with price points based on duration of rentals. @ four days discount, etc.  These individual statements work, but the series doe...
Tables and fields
DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago
Dan:

Got it!  "AND" operator doesn't work.  The information you provided worked just fine  (just a couple more similar lines to create the ranges).

Thank you!  Was getting frustrated.

Dirk
DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago
Rob,

That does help!

I was planning on limiting method of selecting number of days using numeric field in another table.  

Does that make sense?

Dirk