Update Access query

This is a Access query.

Field CompanyID
table jcSRP
Update To: [SRP Schedle ID]

IIf(IsNumeric([SRP Schedule ID],[SRP Schedule ID],0)

The expression you entered has a function containing the wrong number of agruments.
ca1358Asked:
Who is Participating?
 
NightmanCTOCommented:
You missed the closing paranthesis on IsNumeric
0
 
NightmanCTOCommented:
Field CompanyID
table jcSRP
Update To: [SRP Schedle ID]

IIf(IsNumeric([SRP Schedule ID]),[SRP Schedule ID],0)
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Make a backup first, then....

UPDATE jcSRP
SET CompanyID = IIf(IsNumeric([SRP Schedule ID]),[SRP Schedule ID],0)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
NightmanCTOCommented:
Hiya Jimhorn ;)
0
 
ca1358Author Commented:
Thank you!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Rats.  I even posted the SQL too.  

Hi Nightman...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.