Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 05-18-2007, 12:22 PM
Moiraes Fate Moiraes Fate is offline
Can I get some help setting this up please?
Join Date: May 2007
Posts: 1
Moiraes Fate
Default Can I get some help setting this up please?

I'm trying to create a very basic database for my work using Access. I work in a college. We sell the residencies almost like a hotel in the summer. Its been a very long time since I last used Access though and I can't remember how to do some of the calculations. Most of it is done but for a few small things that I want there just to make things easier for my less computer literate co-workers.

I'll slowly expand on this over time, so I hope thats ok. Just so that I can deal with one problem at a time.

I have a checkin date and a checkout date. What I want the program to do is automatically calculate the number of days of the stay when its typed into those respective fields so that the author of the reservation doesn't have to manually calculate in the amount of days using a calculator.

I'd then like it to automatically calculate the amount of money to charge.

There are some variables for this calculation....

I want it to... if we type in $20 per night into a field, it only, but automatically, add's the 4% tax and gives a total.

However, if we type over $20 in the field, it should automatically add 10% tax and give a total.

All of this should be on the sheet for anyone to see.

Can you explain to me how to do this?

Thanks so much.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM
setting up a program to run from your calendar mattz76 Outlook 0 08-22-2007 09:13 PM
Can I get some help setting this up please? Setting Folder Aging Properties Prob Lando Outlook 24 06-07-2006 02:14 AM
setting rules isapaine Misc 0 01-11-2006 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:44 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft