Hi all,

Is there a way of replicating text in a new field of an already established database. i.e. I have included a new field in a database and would like a short routine where i could include the same text in the same field for every record, without having to export it to excel , then including the text and then importing back to access?

Regards:confused:

An update query will do what you want if I understand you correctly.
UPDATE YourTable Set YourField = "The text you want"

Thanks,

The answer was simpler than expected. Tried to complicate the whole matter.

Thanks once again.;)

You're welcome. Glad I could help.