Solved

Update Access query

Posted on 2006-11-16
6
161 Views
Last Modified: 2010-04-30
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
Comment
Question by:ca1358
  • 3
  • 2
6 Comments
 
LVL 29

Expert Comment

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

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

Expert Comment

by:Jim Horn
ID: 17958687
Make a backup first, then....

UPDATE jcSRP
SET CompanyID = IIf(IsNumeric([SRP Schedule ID]),[SRP Schedule ID],0)
0
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
ID: 17958693
You missed the closing paranthesis on IsNumeric
0
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

 
LVL 29

Expert Comment

by:Nightman
ID: 17958698
Hiya Jimhorn ;)
0
 

Author Comment

by:ca1358
ID: 17958836
Thank you!
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 17958877
Rats.  I even posted the SQL too.  

Hi Nightman...
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question