• 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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