Hello, I made a query based on a table.
Now I want to use this query on a report, with grouping.
When I want to group on CODE ( based on the result of a formula, I get an error : "invalid call procedure" )
I don't find the problem.
Hello, I made a query based on a table.
Now I want to use this query on a report, with grouping.
When I want to group on CODE ( based on the result of a formula, I get an error : "invalid call procedure" )
I don't find the problem.
you dont use semi's in INSTR,
INSTR([prodID],"-")
Reports have their own grouping. Do not group in your query-- use Report grouping.
Yes, I know, the query gives me the right result as i want, but when i use this query in a report, and I start grouping through the report it gives me an error on the code
You have to say what the error is and where it happens?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Perhaps you could post a copy of your database with only enough records to highlight the issue. I'm sure some on the forum could help resolve the issue if they had access to the code and logic involved.
like in post one (& maybe 4)?You have to say what the error is and where it happens?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Is there a value for every code?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Probably now is the time to compact the DB and upload it with non sensitive data?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Found the problem there was one record with a / sign instead of a - , in the numbering of my code. Normally it is 00-000 but in one record it was 00/000 and that was the error.
SO problem solved.
Tnx for all the answers
So how did the query work?
My thinking was that it did not find the -, so the value for the Left would be zero?, but that would still error in the query surely?
Edit:
Hmm, seems Left() accepts a zero and returns nothing, whilst Mid() chokes and gives that error?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba