Update Query outputing numbers only

  • Thread starter Thread starter EyeSpec
  • Start date Start date
E

EyeSpec

I am trying to update an Area Code field in a table
to "000" when the field doesn't contain a three digit
number. The table field has to remain a text field for
other relationships and queries. Any suggestions on what
to put in the criteria field to give the desired results.

Thx, Doug
 
Something like the following should set the Area Code to three zeroes if it
currently contains something besides three digits. So "12" would get update to
"000", as would "" and Null field.

UPDATE YourTable
Set [AreaCode] = "000"
WHERE [AreaCode] Is Null
Or [AreaCode] Not Like "###"
 
Something like the following should set the Area Code to three zeroes if it
currently contains something besides three digits. So "12" would get update to
"000", as would "" and Null field.

UPDATE YourTable
Set [AreaCode] = "000"
WHERE [AreaCode] Is Null
Or [AreaCode] Not Like "###"
 
Thank You. That did it. It acually worked without having
to include the null statement.
Thanks again
-----Original Message-----
Something like the following should set the Area Code to three zeroes if it
currently contains something besides three digits. So "12" would get update to
"000", as would "" and Null field.

UPDATE YourTable
Set [AreaCode] = "000"
WHERE [AreaCode] Is Null
Or [AreaCode] Not Like "###"
I am trying to update an Area Code field in a table
to "000" when the field doesn't contain a three digit
number. The table field has to remain a text field for
other relationships and queries. Any suggestions on what
to put in the criteria field to give the desired results.

Thx, Doug
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top