SELECT Statement in a Report
What's wrong with this code? It keeps giving me the ?Error message, and when
I try to run the report, it says there's a problem. It runs in the query
though.
SELECT [tbl_Ideas_Bank.IdeaID]![ tbl_Ideas_Bank.BenefitType],
[tbl_Quarter.QtrEndDate],[ tbl_Quarter.Value]
FROM [tbl_Ideas_Bank],[ tbl_Quarter]
WHERE (((tbl_Ideas_Bank.BenefitType)="ETR & Cash") AND
((tbl_Quarter.QtrEndDate) Between #1/1/2007# And #12/31/2007#)));
Thanks.
|