Update Statement

[Guest]

Hello,

I have a table that contains the following columns: ID Record, Phone Number,
Fax Number

Some of the Phone Number as well as Fax Number fields are blank. I'm trying
to update any blank field in both the Phone Number Column and the Fax Number
column to "9999999999" in one query.

Please help!!!

Thanks!

 

[Duane Hookom]

Try an update query with SQL like this:

UPDATE [that contains the following columns]
SET [Phone Number] = Nz([Phone Number],"9999999999"),
[Fax Number] = Nz([Fax Number],"9999999999");

 

[Guest]

I think it worked PERFECT!! Thanks so much......

Quick question - what is Nz???

Try an update query with SQL like this:

UPDATE [that contains the following columns]
SET [Phone Number] = Nz([Phone Number],"9999999999"),
[Fax Number] = Nz([Fax Number],"9999999999");

--
Duane Hookom
MS Access MVP

Hello,

I have a table that contains the following columns: ID Record, Phone
Number,
Fax Number

Some of the Phone Number as well as Fax Number fields are blank. I'm
trying
to update any blank field in both the Phone Number Column and the Fax
Number
column to "9999999999" in one query.

Please help!!!

Thanks!

 

[Douglas J. Steele]

http://msdn.microsoft.com/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I think it worked PERFECT!! Thanks so much......

Quick question - what is Nz???

Try an update query with SQL like this:

UPDATE [that contains the following columns]
SET [Phone Number] = Nz([Phone Number],"9999999999"),
[Fax Number] = Nz([Fax Number],"9999999999");

--
Duane Hookom
MS Access MVP

Hello,

I have a table that contains the following columns: ID Record, Phone
Number,
Fax Number

Some of the Phone Number as well as Fax Number fields are blank. I'm
trying
to update any blank field in both the Phone Number Column and the Fax
Number
column to "9999999999" in one query.

Please help!!!

Thanks!

 

[Guest]

PERFECTION!! Thank you so much........

http://msdn.microsoft.com/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I think it worked PERFECT!! Thanks so much......

Quick question - what is Nz???

Try an update query with SQL like this:

UPDATE [that contains the following columns]
SET [Phone Number] = Nz([Phone Number],"9999999999"),
[Fax Number] = Nz([Fax Number],"9999999999");

--
Duane Hookom
MS Access MVP


Hello,

I have a table that contains the following columns: ID Record, Phone
Number,
Fax Number

Some of the Phone Number as well as Fax Number fields are blank. I'm
trying
to update any blank field in both the Phone Number Column and the Fax
Number
column to "9999999999" in one query.

Please help!!!

Thanks!