K
Kelvin Leong
Hi there,
I have encountered the following error message while processing a report:
"This expression is typed incorrectly, or it is too complex to be
evaluated...."
The query of my report is as follows:
SELECT Transaction.TodaysDate, Transaction.PaymentFrom,
Transaction.PaymentTo, DriverInfo.VehicleNo, Transaction.NetPayment,
DriverInfo.ManagementCo, Transaction.auto, Transaction.Date,
Transaction.DiscountRM, Transaction.Remark1, Transaction.Remark2,
Transaction.Remark3, Transaction.DiscountGiven, DriverInfo.DailyRate,
DriverInfo.Radio, DriverInfo.MiscPay, DriverInfo.AgreementStartDate,
DriverInfo.AgreementEndDate, DriverInfo.AgreementStatus
FROM DriverInfo INNER JOIN [Transaction] ON DriverInfo.NRIC = Transaction.NRIC
GROUP BY Transaction.TodaysDate, Transaction.PaymentFrom,
Transaction.PaymentTo, DriverInfo.VehicleNo, Transaction.NetPayment,
DriverInfo.ManagementCo, Transaction.auto, Transaction.Date,
Transaction.DiscountRM, Transaction.Remark1, Transaction.Remark2,
Transaction.Remark3, Transaction.DiscountGiven, DriverInfo.DailyRate,
DriverInfo.Radio, DriverInfo.MiscPay, DriverInfo.AgreementStartDate,
DriverInfo.AgreementEndDate, DriverInfo.AgreementStatus
HAVING (((Transaction.TodaysDate) Between [Start Date] And [End Date]))
ORDER BY DriverInfo.VehicleNo DESC;
The problem:
I have been using this report on a daily basis and without fail, my system
generates it for me, until on the date 20/04/2007. I managed to generate the
reports on all other dates, including 21/04/2007, after transactions are
available. This proves that the query or report is not altered in anyway that
generated the above said error.
The strange thing is that running the query alone for the [Start Date] and
[End Date] = 20/04/2007, I will be able to generate the result in the
datasheet view.
However, if I run it as a report, having the [Start Date] and [End Date] =
20/04/2007, I will get the above said error. I even took the liberty to try
out the range [Start Date] = 19/04/2007 and [End Date] = 21/04/2007 and have
the same error.
I suspect that any result that have anything to do with the date =
20/04/2007 will generate this error. Can anyone help me on how to solve this
problem?
I have encountered the following error message while processing a report:
"This expression is typed incorrectly, or it is too complex to be
evaluated...."
The query of my report is as follows:
SELECT Transaction.TodaysDate, Transaction.PaymentFrom,
Transaction.PaymentTo, DriverInfo.VehicleNo, Transaction.NetPayment,
DriverInfo.ManagementCo, Transaction.auto, Transaction.Date,
Transaction.DiscountRM, Transaction.Remark1, Transaction.Remark2,
Transaction.Remark3, Transaction.DiscountGiven, DriverInfo.DailyRate,
DriverInfo.Radio, DriverInfo.MiscPay, DriverInfo.AgreementStartDate,
DriverInfo.AgreementEndDate, DriverInfo.AgreementStatus
FROM DriverInfo INNER JOIN [Transaction] ON DriverInfo.NRIC = Transaction.NRIC
GROUP BY Transaction.TodaysDate, Transaction.PaymentFrom,
Transaction.PaymentTo, DriverInfo.VehicleNo, Transaction.NetPayment,
DriverInfo.ManagementCo, Transaction.auto, Transaction.Date,
Transaction.DiscountRM, Transaction.Remark1, Transaction.Remark2,
Transaction.Remark3, Transaction.DiscountGiven, DriverInfo.DailyRate,
DriverInfo.Radio, DriverInfo.MiscPay, DriverInfo.AgreementStartDate,
DriverInfo.AgreementEndDate, DriverInfo.AgreementStatus
HAVING (((Transaction.TodaysDate) Between [Start Date] And [End Date]))
ORDER BY DriverInfo.VehicleNo DESC;
The problem:
I have been using this report on a daily basis and without fail, my system
generates it for me, until on the date 20/04/2007. I managed to generate the
reports on all other dates, including 21/04/2007, after transactions are
available. This proves that the query or report is not altered in anyway that
generated the above said error.
The strange thing is that running the query alone for the [Start Date] and
[End Date] = 20/04/2007, I will be able to generate the result in the
datasheet view.
However, if I run it as a report, having the [Start Date] and [End Date] =
20/04/2007, I will get the above said error. I even took the liberty to try
out the range [Start Date] = 19/04/2007 and [End Date] = 21/04/2007 and have
the same error.
I suspect that any result that have anything to do with the date =
20/04/2007 will generate this error. Can anyone help me on how to solve this
problem?