If (condition) Then Hide ?

[soldieryap]

In the query, i want some Column hiding when some Column is not satisfy my require, how i do it in query?

FOR AN EXAMPLE:
colour: blue
ball : -

when the colour is blue, i want to hide the [ball] column.

thanks for help.

 

[braindead2]

not sure if this is what you mean but I think something like this would work.
put color in the QBE grid and this in the field next to it
exp1:IIf([color] = "Blue", "",[ball])