Select based upon a seperate boolean field

[CABman01]

Good morning,

I am trying to fugure out how to select a value and show it based upon a boolean.

I have a access database that has a table where the values I want to output need to be put together. I want the value output in the group field. (i.e. Modification: Width X Height X Depth).

Width Depth Height WidthMOD DepthMOD HeightMOD
12 12 12 0 0 0
12 24 24 0 -1 -1

sudo code:
if WidthMOD or DepthMOD or HeightMOD = True Then
output "Width & Depth & Height"
endif

Ideas???


Michael

 

[lupins46]

Create a formula field:

if {mytableWidthMOD}= true or {mytable.DepthMOD}= true or {mytable.HeightMOD} = True Then
{mytable.Width} & ":" & {mytable.Depth} & ":" & {mytable.Height}
else
""

Put this into the detail line and Group on this formula field.

 

[CABman01]

Thanks, that worked. I was trying to do the same thing, but was working in the select expert. My bad!

Michael