Recent content by Aboord

Hello Party people, I have written a union querry which runs for a bit then gives me this error message Data type mismatch in criteria expression. (Error 3464) The explanation for the error is as follows. The criteria expression in a Find method is attempting to compare a field with a...

Thanks Banana and mailman, thanks for the advice. i used a bit of both of your commenst. This was my first time using the switch syntax and i finally got a hang of it and got the querry to work. i then took it a step further by taking mailmans comments and creating a querry which pulls the dates...

Hi, top of the day to you, I am trying to write a case statement in access from the sql view. It doesn't seem to work so i tried the switch syntax which returns an error. Is it possible to use the case syntax in access sql view? if not how can i do this. this is my sample query SWITCH (...