Invalid Procedure Call On my Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used Left([PartCode],InStr(1,[PartCode],",",-1) to get part of a
string Last Name, First Name. The last name is pulling fine in my query
however I am getting an Invalid Procedure Call when I put this field my
header field on my report.

Any suggestions
 
M,
Try...
Left([PartCode], InStr([PartCode],",") -1)
But, if you've already got it working in the query behind the report you
should be able to use that calculated bound field.
If you had...
DerivedLastName : Left([PartCode], InStr([PartCode],",") -1)
in your query, then just [DerivedLastName] on your report should display the
correct value.
 
I think I have added the field to my report header correclty. On the report
I have used the field name tool and pulled the field name to where I want it
displayed.

Al Camp said:
M,
Try...
Left([PartCode], InStr([PartCode],",") -1)
But, if you've already got it working in the query behind the report you
should be able to use that calculated bound field.
If you had...
DerivedLastName : Left([PartCode], InStr([PartCode],",") -1)
in your query, then just [DerivedLastName] on your report should display the
correct value.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

M Wells said:
I have used Left([PartCode],InStr(1,[PartCode],",",-1) to get part of a
string Last Name, First Name. The last name is pulling fine in my query
however I am getting an Invalid Procedure Call when I put this field my
header field on my report.

Any suggestions
Click to expand...
Click to expand...
 
Back
Top