Keeping a field with the same data all throughout the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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
Click to expand...

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]
 
Back
Top