I need help with a report in Access 2000! How would you do this?
If [checkbox 1] is checked and [checkbox 2] is not checked then [Total] textbox should have same value as [field 1].
If [checkbox 2] is checked and [checkbox 1] is not checked then [Total] textbox should have same value as [field 2].
If [checkbox 1] and [checkbox 2] are both checked then [Total] textbox should have value of ([field 1] + [field 2]).
Report Example:
Field 1 Field 2 CheckBox 1 CheckBox 2 Total
5 2 X 5
3 3 X 3
4 5 X X 9
I'm pretty sure I need an IIf statement in the Total textbox record source, but I not sure of the syntax.
Can anyone help me?
If [checkbox 1] is checked and [checkbox 2] is not checked then [Total] textbox should have same value as [field 1].
If [checkbox 2] is checked and [checkbox 1] is not checked then [Total] textbox should have same value as [field 2].
If [checkbox 1] and [checkbox 2] are both checked then [Total] textbox should have value of ([field 1] + [field 2]).
Report Example:
Field 1 Field 2 CheckBox 1 CheckBox 2 Total
5 2 X 5
3 3 X 3
4 5 X X 9
I'm pretty sure I need an IIf statement in the Total textbox record source, but I not sure of the syntax.
Can anyone help me?