Udate Syntax Help

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

Guest

I have a phone # field that I need to import into another program. Before
for I create the csv file to import I need to put a 1 in front of each record.

Record #1 = 4025555555

I need to run an update query that will make theis 14025555555

Is there an easy way to do this?

Thanks in advance
 
I have a phone # field that I need to import into another program. Before
for I create the csv file to import I need to put a 1 in front of each record.

Record #1 = 4025555555

I need to run an update query that will make theis 14025555555

Is there an easy way to do this?

Thanks in advance
Click to expand...

It's not actually necessary to update your stored data to export it
with the 1 appended; you can just create a Query with a calculated
field

ExpPhone: "1" & [phonenumber]

and export from the Query.

If you do wish to permanently add the 1 to your table (and probably
change all your forms and reports to accommodate this change) you can
run an Update query updating the field to

"1" & [phonenumber]

assuming again that the field is in fact named [phonenumber].

John W. Vinson[MVP]
 
Back
Top