>I'm having to do a SQL Select on an Access 95 database.
>
>One of the fields is type Currency.
>
>The value passed over to compare it to is of type Numeric.... so I get an operator/operand type mismatch.
>
>What is an easy way to compare the two?
>
>Thanks
Can you show some code? It supposed to work. Maybe can you try to explicitly convert using CCUR.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com