Adding Prefix to multiple rows n Access? Help!

  • Thread starter Thread starter Christine via AccessMonster.com
  • Start date Start date
C

Christine via AccessMonster.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
 
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.


message 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
 
Christine:

My syntax was off just slightly. Please try the following:

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.


message 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
 
Sorry, actually I am trying to update 1500 rows? Your query gives me option
for one at a time instead of automating it?
 
Christine said:
Sorry, actually I am trying to update 1500 rows? Your query gives me
option for one at a time instead of automating it?
Click to expand...

No, it updates all the rows at once. There is no where clause so all
records are affected.
 
Back
Top