Data type mismatch in criteria expression - error msg

[dastr]

Hi all,

I get the below error msg:

Data type mismatch in criteria expression

when running a macro in Access; the only way to solve it is to go to the source table, change one field from BINARY to TEXT which solves the issue, however I would like to avoid doing this interim step manually, any ideas how I may solve that issue once and for all?

Thank you

 

[Addyman]

Could you post your macro? Or the part of it that is causing the error?

Thanks.

 

[dastr]

Hi there,
Thanks for reacting; here below the sql:

TRANSFORM Sum([tbl AA].[Int FOB]) AS SumOfScore
SELECT [tbl AA].P3
FROM [tbl AA]
GROUP BY [tbl AA].P3, [tbl AA].[Article #]
PIVOT [tbl AA].Rank;

The issue us that Int FOB appear in tbl AA in binary format I need everytime to go to that table and manually change it to Text for the above query to work.

Thanks

Could you post your macro? Or the part of it that is causing the error?

Thanks.