By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,286 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,286 IT Pros & Developers. It's quick & easy.

Novice Question - I wish to modify the data in multiple feilds

P: n/a
Hi There;

This is a silly question but I have to ask this.

I want to create a query (SQL statement would be good!) that will do
the following:

1. modify the data in the field of my choice;
2. but keeps the present data intact.

Example: In the field "Subject" , I have "Test One - do this" . I want
to modify ALL of the "Subject" fields to have (current data) + " and
then do this"

Am I being clear? What SQL command would one use for this??
Examples??

Thanks

Z

Dec 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
MLH
Prepending or Appending a string to another string is easy. Your
query shows the field names in the QBE grid. If a field name is
[MyTest] then use an UPDATE query to update [MyTest] to
[MyTest] & " and then do this"

xxxxxxxxxxxxxxxxxxxxxxxxxx
Example: In the field "Subject" , I have "Test One - do this" . I want
to modify ALL of the "Subject" fields to have (current data) + " and
then do this"

Am I being clear? What SQL command would one use for this??
Examples??

Thanks

Z


Dec 13 '05 #2

P: n/a
Hey...thank you SO much for your help! I was just getting the syntax
wrong but you put me in the right direction!

Thanks again!

Z

Dec 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.