Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Solving "Invalid Procedure Call" error on running query
Golum, FYI solved the problem; thanks for the improved code! Error was arising in: IIf(Len([Section Code])=1," ",Mid([Section Code],1,3) & Mid([Blanks],1,3-Len([Section Code]))) AS [Sec Code] Section code on the input data contained a value "#" on one particular record which gave the error...- Laura776
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Solving "Invalid Procedure Call" error on running query
Hi! thanks for your help, the SQL is very lengthy - but here goes. As I said, it worked fine for sometime. When viewed in design view, it's not so difficult to follow: SELECT DISTINCT [Comet Header & Footer Query].[Header 1], Mid([Zeros],1,(15-Len([Job No]))) & +[Job No] AS...- Laura776
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Solving "Invalid Procedure Call" error on running query
Hi, I've got a fairly complex query that has been running quite happily in Access 2000. I made some changes to the queries in Access 2000 and they worked fine. The corporate standard has now upgraded to Access 2003. The database still works, but one specific query keeps throwing up a "Invalid...- Laura776
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
