munkeyroot
Registered User.
- Local time
- Today, 17:36
- Joined
- Jan 13, 2011
- Messages
- 76
Hi Everyone
hope you can help i am a little stuck on a project
i have a text box called percent - i don't want to use the amount as a customer may see this so i have a table with, and created a query for it.
Grade | Percent
A = 10
B = 15
C = 20
and made the Percent text box a combo box. and set the row source to the query.
on another text box i have the below code that i need to multiply the percent by.
=Nz(([CostofInstallation]*[Percent]),0)
how do i the code to choose the percent amount from the grade i enter.
hope this make sense
cheers
Munk
hope you can help i am a little stuck on a project
i have a text box called percent - i don't want to use the amount as a customer may see this so i have a table with, and created a query for it.
Grade | Percent
A = 10
B = 15
C = 20
and made the Percent text box a combo box. and set the row source to the query.
on another text box i have the below code that i need to multiply the percent by.
=Nz(([CostofInstallation]*[Percent]),0)
how do i the code to choose the percent amount from the grade i enter.
hope this make sense
cheers
Munk