Queries and views are database specific. If you want a permanent change, go ahead and change the query/view in the database. Since you are using the word query, I'm going to suppose you have an Access DB. You can't get to the structure of an Access query except with DAO. In SQL Server if you want to use ALTER VIEW, you still must supply the entire new SQL statement.<BR><BR>I think an Access query can be used exactly like a table so you might also try:<BR>Select query_name.*, table_w_column.column_name From query_name JOIN table_w_column ON join_expression <BR><BR>If join_expression is not on unique values, be prepared for some very surprising results.