>>Hi Erik,
>>yes, a bit different question, however on the same idea. The syntax error wasn't from the report . . . the report is small, and I combed it thoroughly.
>
>What line throws the error? Where are you running this SQL from? BTW, you probably want to use the INTO CURSOR clause here to prevent a browser window from opening when the query completes.


public gdValue
gdValue = Thisform.gd1.displayvalue

public szValue
szValue = Thisform.sz1.displayvalue

select bundle,length,grade,siz,shipdataid; <-- This Line Erik
from data1;
into cursor 2ft; <-- Into Cursor
where grade . . .