Invalid Procedure Call Error Using InStr

[dsg1480]

Hi All,

I have a query in which there are 10 fields that contain text which I want to convert into integers. I want to take all of the numbers to the left of the "." (each one has a format of "xx.0bp", however it could also be "xxx.0bp"). I used the formula:

Int(Left([Target_Field],Instr([Target_Field,".")-1))

The formula works fine for the first two fields, but if I place it in the third field I receive a "Invalid Procedure Call" error message when I run the query.

Does anyone know how to solve this problem?

 

[boblarson]

TargetField probably has a null value. Wrap it in the NZ function to handle the nulls.

 

[dsg1480]

TargetField probably has a null value. Wrap it in the NZ function to handle the nulls.

Pretty sure you are 100% correct...thanks!!