[AccessD] SELECT * (except some columns)

Hi Joe

As far as I know, the answer is no.
But why not just ignore that column? If you are viewing the query, set
the column width to zero.

/gustav

> I am writing a query that joins one table to two cross-tab queries.

> All three tables are linked via a common column (EmployeeID).

> Because of the nature of the cross-tab queries, i.e. the number of columns
> will increase every month, I had to use the CrossTabQuery.* selection in my
> joining query. 
> Everything works out well, but I was wondering if there was someway to
> select all the columns from the crosstab queries except for the EmployeeID
> column.

> In essence, it could be thought of as: SELECT * - CrossTab.EmployeeID