HELP! Very Simple Query

[tammythack]

I need to figure out how to display a 15% discount on a weekly rate field
(I'm new to access, taking classes, and in the book it suggests that I should use Microsoft Access help to solve this problem--- HA!)
The question reads: "Owner ID: ML10 offers a 15% discount on the weekly rate if renter rents for more than one week at time. What the weekly rental rate for his units?"
Please bear in mind that I have only had only had 2 classes so far, and I am totally lost and have no clue as to what to look for in the help files. I know I need to display the Owner ID field, and the weekly rate field, I just cannot for the life of me figure out how do enter the information to get the caculated discounted weekly rate.
If some one could tell me how to do this I would be eternally grateful

 

[Rich]

Look up DateDiff and calculated controls

 

[tammythack]

OK, I'm sure there is a simpler way to do this (heck I can barley figure out how to post to this forum!)
anyway, here is what I did...

I added an expression 15% off: [Weekly Rate]*0.15
then added another expression Discount Rate: [Weekly Rate]-[15% off]

Owner ID---Address -----Weekly Rate----15% off----Discount Rate
ML10---------521 Ocean----$750.00------$112.50----$637.50
ML10---------956 First------$1,100.00----$165.00----$935.00

Now how do I get it to only display the owner id, address, and discounted weekly rate fields?
When I uncheck the 15% off field, and click the view button I am prompted to enter Paramater Values???

 

[tammythack]

Re: Re: HELP! Very Simple Query

OK, I'm sure there is a simpler way to do this (heck I can barley figure out how to post to this forum!)
anyway, here is what I did...

I added an expression 15% off: [Weekly Rate]*0.15
then added another expression Discount Rate: [Weekly Rate]-[15% off]

Owner ID---Address -----Weekly Rate----15% off----Discount Rate
ML10---------521 Ocean----$750.00------$112.50----$637.50
ML10---------956 First------$1,100.00----$165.00----$935.00

Now how do I get it to only display the owner id, address, and discounted weekly rate fields?
When I uncheck the 15% off field, and click the table view button I am prompted to enter Paramater Values???

I figured out how to only show the desired fields in table view, right click, select hide column, but I still can't seem to figure out how to simplify the expression, (or complicate it which ever be the case) so there is only one expression column instead of 2

 

[Nouba]

put all calculation formulars together into your desired field.

Discount Rate: [Weekly Rate]-[Weekly Rate]*0.15

 

[tammythack]

put all calculation formulars together into your desired field.

Discount Rate: [Weekly Rate]-[Weekly Rate]*0.15

Thank you !