Selective fields

shbond

New member
Local time
Today, 16:17
Joined
Jul 12, 2001
Messages
5
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?
 
This seems like a strange solution, but it might work:
If the default value of the field is blank, could you stack the three fields on top of each other in your report? Only one would have data, so it would look like one field.
However, labeling what it is might be problematic.

Is your report too crowded just to place them side by side?
 

Users who are viewing this thread

Back
Top Bottom