Fixed values in a column?

[Bobby9779]

Hey,

Is it possible for me to make a table and have a column with fixed values.

My plan is to have a table that records can be added to (with one column already assigned).

The records will be added via a query.

I don't know if this is possible, is it possible to have fixed a column that records can be deleted and inserted without the values changing in one column?

Almost like an autonumber, but that does not change if you delete and insert records? That would be perfect!

 

[gemma-the-husky]

you can set a fixed value in a query. just put whatever you want in the header, and select the field to append to, at the bottom.

It's hard to see the use of a constant though.