MS Access Query Display Column Conditionally

[telecomadmin12]

I have a query in access. Certain columns I would like to show only, if the value of a field in another column is not empty.
How would I do that?

 

[Andrzejek]

A 'Report' comes to mind...

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[dhookom]

This question really belongs in the [forum701]. You should really post some example data, your rules/specification, and desired query display.

Duane
Hook'D on Access
MS Access MVP