Christine:
If you are trying to add "AD -" to the beginning of one field in the row
then the following query would be one alternative.
UPDATE Test1 SET Test1.TextField = "AD -" & "TextField";
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"Christine via AccessMonster.com" wrote in
message news:ce2be60a4ef94e1ab13cda97c87d2d26@AccessMonste r.com...
Hi,
I am trying to add Prefix to about 1500 rows in an access table.
e.g. if there is dfferent data in 1500 rows, I would like to add "AD - "
infront of each row.
Is is possible in Access without typing this manually?
I would really appreciate any response.
Thanks,
Christine