I have a report which I would like to generate with different fields depending on the data entered into those fields.
Let me explain further....
I have 3 fields called saving, costred, and costavoid. For each record there may be data in only one of the fields. I would like my report to show only the field with data enetered and to position the result in the same position on the report no matter which field the data is sourced from.
I have tried using an If expression in the control source property for the text box I would like the result to be displayed in, but it doesn't seem to work. Am I trying the impossible or is there another way of doing this?
Let me explain further....
I have 3 fields called saving, costred, and costavoid. For each record there may be data in only one of the fields. I would like my report to show only the field with data enetered and to position the result in the same position on the report no matter which field the data is sourced from.
I have tried using an If expression in the control source property for the text box I would like the result to be displayed in, but it doesn't seem to work. Am I trying the impossible or is there another way of doing this?