[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

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.
0
ca1358
Asked:
ca1358
  • 3
  • 2
1 Solution
 
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
 
NightmanCTOCommented:
You missed the closing paranthesis on IsNumeric
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now