If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invalid Procedure Call On my Report
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 |
#2
|
|||
|
|||
Invalid Procedure Call On my Report
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" wrote in message ... 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 |
#3
|
|||
|
|||
Invalid Procedure Call On my Report
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" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
Invalid Procedure Call | CK | Using Forms | 2 | May 7th, 2005 04:53 AM |
Invalid Procedure Call Message | Anthony Viscomi | General Discussion | 1 | March 16th, 2005 03:15 PM |
How do I call a SQL Server Stored Procedure from an Access Report. | DJCovall | Setting Up & Running Reports | 2 | January 21st, 2005 03:50 PM |