Add column to query table

  • Thread starter Thread starter Mimi
  • Start date Start date
Mimi
How do you edit a query table. I want to add a column.

In Access terminology, there's no such thing as a "query table". You have
tables, that store data, and queries, that select/return data (and do other
things).

You want to add a column. What will be in that column? Will you need to
keep whatever it is permanently? If so, maybe you need to add a column to a
table.

Will it be for display only? If so, you can create a new field in a query
you already have, and either display an additional field from the table, or
use an expression to show something new -- the key here is that you DON'T
need to preserve whatever it is, just show it each time you run the query.
 
Back
Top