hiding columns

[buggy2]

I am using Docmd.openquery to query a table using selected values from combo boxes as parameters. However I would like to limit the number of columns I am showing when the results are requested. The results are shown in datasheet view.

eg. if the user selects to see the sum of values, the query will return both the sum and average in the datasheet view.

I dont want to generate seperate queries. I basically want the VBA for hiding columns, the average column in the example above.

Sendkeys could be used as a last resort.

 

[buggy2]

reset the width

I have just realised I can do what I need to do by reseting the column width to 0. Does anyone know how to select a column of a query in a datasheet view and hide a column using vba.