I have 2 problems here. Firstly I have an sql statement which works when cut and pasted into crystal but not when run from VB6 as selection criteria. If I null the selection criteria the report prints so I know the sql is not working - any ideas?

Also, when running a report from a query I get runtime error 3356 (attempting to opena database already opened exclusively) This is just an Access database on a network and I am querying it in order to report. Anyone know what I might be doing wrong? Help!