Hi All,



I am trying to write a query which takes data from a form and then applies this input to the 'show' column in the query and this dictates if the column is shown in the resulting output.

The setup I have is a query that includes one main table(School) with several tables linked to this, the complete school table is in the query with 1 column out of each of 5 tables included.

I have a form which has yes/no boxes for the 1 column of each of the 5 tables - now I can pass the yes or no from the form to the query for each column but how do I make the yes mean show the column in the query output and the no to mean hide the column?


Not sure if this is possible but any help would be much appreciated

Steve