Hello!

Okay, the question doesn't have much to do with dotnet but more with crystal reports itself. Sorry about this.

Maybe anyone could explain to me how to add a sql query (well, an 'exists' query like 'and not exists record with the same itemcode and different inserttime') into a report based on an MS Access database (no ODBC connection I'm afraid).

I tried to use the sql designer but that requires an ODBC connection as far as I can tell.

Thanks for helping,
Wyv

I forgot, I use Crystal Reports 8.5.

Thanks.