Problem grouping

[gunterh]

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.

[ranman256]

you dont use semi's in INSTR,
INSTR([prodID],"-")

[orange]

Reports have their own grouping. Do not group in your query-- use Report grouping.

[gunterh]

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

[Welshgasman]

You have to say what the error is and where it happens?

[orange]

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.

[Micron]

You have to say what the error is and where it happens?

like in post one (& maybe 4)?

[Welshgasman]

Is there a value for every code?

[gunterh]

Is there a value for every code?

yes for every code I have a value.

[Welshgasman]

Probably now is the time to compact the DB and upload it with non sensitive data?

[gunterh]

Probably now is the time to compact the DB and upload it with non sensitive data?

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

[Welshgasman]

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?