Thanks for your suggestions, but I continue to get errors...
When I put "WHERE (GlTrans.Period_Date < ?)" I get the error message
"Parameters are not allowed in queries that can't be displayed
graphically".
If I put the questionmark in single quotes I get an error message
"Cannot convert ? to a time stamp".
If in double quotes I get a "Column '?' not found error.

Any other thoughts?
Brian
Business Analyst
JDIS

*** Sent via Developersdex http://www.developersdex.com ***