JDGraham said:
i have a control called "member status" that indicates
whether a person is an Associate, Candidate, or Member.
I want to create a report that will show $250 as the
membership dues for a Member or Associate, but only
$125 for a Canddidate. What expression can I create
that will do this?
If the memberstatus text box actually contains those text
strings, then the dues text box could have an expression
something like:
=IIf([memberstatus]="Candidate", 125, 250)
but having data values (Candidate, 125 and 250) in the code
is definitely not a good programming practice.
You should add a duws field to a member types table. The
table would then have at least three fields:
MemberType TypeName TypeDues
1 Candidate 125
2 Associate 259
3 Member 250
This provides much more flexibility and allows the member
type names and/or dues to be changed without affecting the
program's code. With this kind of arrangement the
membership table would ony have the member type firld and
you could Join the member types table to the membership
table on the member type fields in the report's record
source query. This way you would nor need an expression to
display the dues since it would be another field in the
query.
