Hey guys,
I've had a bit of a look through and I've been googling this and searching around for a few weeks now, but with no avail. I've been working on a database for school -- a motel database to be specific -- and I've encountered a problem.
The business that I'm creating this database for has a 'cot' option, which allows for the customer to have a cot in their room at an added fee of $10 to the current room cost.
Basically, I just need $10 (or just 10) to be added to the "Payment Due" field once the "Cot" checkbox is checked.
You help would be appreciated so much. I've been looking for so long and I thought something this simple would be a common problem, but evidently not. Thanks in advance for any help you can give.
Pic related: