Querydef problem in Access

Hey,
I am try to be able to use a variable as the criteria of a select query. I keep getting a compile error as soon as I enter the SQL statement. The problem I think is that I have to select about 25 fields and I think the statement is too long. I try adding line breaks and continuing it on the next line but I get the same errors. Is this just another reason to hate Access or is there a workaround?

Yes, there is a limit in a sql string in Access. Post your query string and I will try to optimize it.