MS Access 2007 reserved error (-1524)

Dear Experts,

  I have an Access 2007 front-end application with a .mdb file extension and the tables are linked to an MS SQL Server 2000 database.  This Access 2007 front-end application was converted from MS Access 2003.  

  I need a report that displays records of today's date within a range of time and yesterday's date within a range of time.  This report will include a field name "createdTime" with data type as Date/Time.  This "createdTime" filed only contains Time information.

  Here is the Query I used for this report:


SELECT *
FROM Book
WHERE createdDate=(Date()-1) And (Format(createdTime,'hh:mm:ss') Between "20:00:00" And "22:59:59") Or
createdDate=Date() And (Format(createdTime,'hh:mm:ss') Between "00:00:00" And "03:00:00")

ORDER BY createdDate, createdTime, isbnNumber;

 
   For report itself, I used one that was created in Access 2003, and associate it to the query above.


MY QUESTION

1.  The Query itself executed fine.  When I double click on the Query, it is able to return records in Datasheet
     View.  However, if I double click on the Report, it gives me an error message:

 "Reserved error (-1524); there is no message for this error."

2.  If I right click on the Query and attempt to Export it to a Text file, I got the same error message:

 "Reserved error (-1524); there is no message for this error."


How do I resolve this problem?


Thank you!