Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query
I mentioned that at the end of my original message. I've tried it both
ways and it doesn't solve the problem.
The query is good. For some reason though Access or MySQL is removing
the IF statements in the middle of it.
What next?
Freddie Sorensen [EMAIL PROTECTED] 2/26/04 12:25:03 PM
Ed
