Help with a report field
- From: "deercreek" <dan@xxxxxxxxxxxxxxx>
- Date: 15 Dec 2005 10:11:34 -0800
Can you write an if satement in a control source fild of a text box to
do the following. I am trying to get it to look at another field in the
form and depending upon what text is in that field it would return a
value. So if in the Site text box says rv1 or rv2 etc I want the other
field to show $20. Or if it has T101 or T102 etc. the the other field
would show $10. I think this should be possible. I don't know if I'm
trying to doit in the wrong area or if my syntx for the if statement is
just wrong. Any help would be apperciated.
Thanks
Dan
.
- Follow-Ups:
- Re: Help with a report field
- From: Larry Linson
- Re: Help with a report field
- From: Steve
- Re: Help with a report field
- Prev by Date: Access fails if printer is out of paper
- Next by Date: Re: How to Test Function in Immediate Window
- Previous by thread: Access fails if printer is out of paper
- Next by thread: Re: Help with a report field
- Index(es):