Very Computer

by **Jonathan P Higgi** » Sat, 26 Sep 1998 04:00:00

Hi,

I'm having a problem with Crystal Reports. It doesn't seem to be able to see
a regular select in my Access 97 database. I'm not sure what the problem is.
The query is simply an inner join on two tables with some sorting.

This is the query:

SELECT Referrals.OriginalIL, Transactions.oclc_code, referrals.il_number AS
[Outgoing Number], Referrals.DateCreated, Referrals.LenderString,
transactions.status
FROM Referrals INNER JOIN Transactions ON Referrals.OriginalIL =
Transactions.Il_number
WHERE (((Referrals.DateCreated)<DateAdd("d",-24,Now())) AND
((IsNull([datereported]))<>False))
ORDER BY Transactions.oclc_code, Transactions.Il_number;

Is there anything in the syntax of the query that would throw off Crystal
Reports?

Thanks

by **Tadeusz Schuste** » Wed, 30 Sep 1998 04:00:00

try compose your query using access97, then choose sqlview
your sql statement will be ok (hope)
copy statement and paste into your crystal project

best
Tadeusz Schuster, Krakow, Poland
--

Jonathan P Higgins napisa3(a) w wiadomo?ci:

Quote:>Hi,

>I'm having a problem with Crystal Reports. It doesn't seem to be able to
see
>a regular select in my Access 97 database. I'm not sure what the problem
is.
>The query is simply an inner join on two tables with some sorting.

>This is the query:

>SELECT Referrals.OriginalIL, Transactions.oclc_code, referrals.il_number AS
>[Outgoing Number], Referrals.DateCreated, Referrals.LenderString,
>transactions.status
>FROM Referrals INNER JOIN Transactions ON Referrals.OriginalIL =
>Transactions.Il_number
>WHERE (((Referrals.DateCreated)<DateAdd("d",-24,Now())) AND
>((IsNull([datereported]))<>False))
>ORDER BY Transactions.oclc_code, Transactions.Il_number;

>Is there anything in the syntax of the query that would throw off Crystal
>Reports?

>Thanks

Very Computer

Crystal Reports not recognising query

Crystal Reports not recognising query

Crystal Reports not recognising query