hide column in query

[tourguy]

I have a query that has the fields: fldname, fldcomputers, fldsuppliers, fldIT, flddate.
What i want to do is search for a name, say "John". Once it finds John, I want to see if he is in a fldcomputer(is a true/false checkbox )or fldsuppliers(true/false checkbox). If fldcomputer is checked and fldsuppliers is not, then I want to hide the column fldsuppliers, but leaving the other fields visible in the query. If fldcomputer is not checked and fldsuppliers is checked, then I want to hide the fldcomputer, and leaving the other fields visible.

 

[sera]

I believe that you will have to use a report to do this. You can write code behind the forum to hide a value or show a value base on a certain criteria. Let me know if I can help you further!


Sera
I often believe that...
My computer is possessed!

 

[Golom]

Sorry but a query has a fixed number of columns for every record. You can, using an IIF for example, put an empty string into a column but eliminating the column completely is not an option.