Invalid argument when saving simple query

[baker9over]

I have a query which searches resords in two tables. I use the Left and Right functions and the query runs "Perfect". Problem comes when trying to save said query - I get an invalid argument when saving. Any ideas ???

 

[DanJR]

hi there,

I don't know why its doing what it does, since it compiles ok... have you tried copying the sql statement into new query? Check the query properties and see if anything is strange there...Check for any broken dll references as well (can cause problems when sql calls vba functions - although i can't see how it could interfer will saving query.

Dan