Keeping a field with the same data all throughout the table

[CCHON]

I have an imported table. I have added a new column entitled Channel. IN
this field, I would like to keep the consistent text "reseller". Is there a
way to do this so that no matter how many rows this table has, and any
queries done against it will pull this constant text? Basically I am trying
to fill down the word "reseller" all throughout the rows.

 

[Douglas J. Steele]

If you really need that field, you could run an Update query to populate the
field for each row.

However, why not leave it out of the table, and write a query that has it as
a computed field? Use the query wherever you would otherwise have used the
table.

 

[CCHON]

Or when I create a query against the table (leaving out the field altogether
from the original table) can I use calculated filed as well? How do I do
this? Sorry- first time to do a calculated field

 

[John Vinson]

Or when I create a query against the table (leaving out the field altogether
from the original table) can I use calculated filed as well? How do I do
this? Sorry- first time to do a calculated field

Simply go to a vacant Field cell in the query design grid and type

Channel: "Reseller"

in it. Every record will now have a field named Channel (identified to
the left of the colon) and the value Reseller.

John W. Vinson[MVP]