J
judy b
I have a report (in Access 2000) that stopped working today after
functioning perfectly since I built it weeks ago. When the report is
launched from a button using a macro, a form pops up and asks for the
Beginning Call Date. When I now type in the date (the same way I
always have) I now get an error that states "This expression is typed
incorrectly, or is too complex to be evaluated....".
The data for the report is called using an embedded querie that I
built using the SQL Statement Query Builder. The following is the SQL
statement for the Querie:
SELECT [COURSE_ CALENDAR].Course_Start_Date, [COURSE_
CALENDAR].[2_ltr_Course_Code], [COURSE_ CALENDAR].Course_Airport,
[COURSE_ DESCRIPTION].Week_Long_Designation, [COURSE_
CALENDAR].COURSE_CAN, COMPANY.[Company Name], COMPANY.Address,
COMPANY.City, COMPANY.State, COMPANY.Phone, [ORDERS_ DETAILS].ID,
[ORDERS_ DETAILS].Registration_Date, [ORDERS_ DETAILS].First_Name,
[ORDERS_ DETAILS].Last_Name, [ORDERS_ DETAILS].License_1, [ORDERS_
DETAILS].Amount_Paid, [ORDERS_ DETAILS].Install_2, [ORDERS_
DETAILS].Install_3, [ORDERS_ DETAILS].Install_4, [ORDERS_
DETAILS].Date_Paid, [ORDERS_ DETAILS].TC_Amount, [ORDERS_
DETAILS].TC_Type, [ORDERS_ DETAILS].Shipping, [ORDERS_ DETAILS].Tax,
[Tax]+[Shipping] AS [T & S],
[Amount_Paid]+[Install_2]+[Install_3]+[Install_4] AS Payments,
[Costo]+[bkcosto]+[T & S]-[TC_Amount] AS Total_Due, [ORDERS_
DETAILS].REG_CANCEL, [ORDERS_ DETAILS].Bkcosto, [ORDERS_
DETAILS].COSTO, [COURSE_ DESCRIPTION].Course_order, HOTELS.HOTEL_NAME,
HOTELS.HOTEL_ADDR, HOTELS.HOTEL_CITY, HOTELS.HOTEL_STATE,
HOTELS.HOTEL_ZIP, HOTELS.HOTEL_TEL, HOTELS.HOTEL_CONTACT,
HOTELS.HOTEL_FAX FROM HOTELS INNER JOIN ([COURSE_ DESCRIPTION] INNER
JOIN ([COURSE_ CALENDAR] INNER JOIN (COMPANY INNER JOIN [ORDERS_
DETAILS] ON COMPANY.Phone = [ORDERS_ DETAILS].Phone) ON [COURSE_
CALENDAR].ID = [ORDERS_ DETAILS].COURSE_CALENDAR_ID) ON [COURSE_
DESCRIPTION].ID = [COURSE_ CALENDAR].COURSE_DESCRIPTION_ID) ON
HOTELS.ID = [COURSE_ CALENDAR].HOTELS_ID WHERE ((([COURSE_
CALENDAR].Course_Start_Date)>=[forms]![ReportRange3]![Beginning Call
Date]) AND (([COURSE_ DESCRIPTION].Week_Long_Designation)<>"exam
prep"));
The criteria for the Course_Start_Date (from the first line of the SQL
statement) is:
I have a dozen reports built using the same technique, so I would
appreciate any fixes for the current problem as well as thoughts as to
why it happened in the first place in case it happens again.
Also, the querie works when I run it from the SQL builder.
Thanks.
functioning perfectly since I built it weeks ago. When the report is
launched from a button using a macro, a form pops up and asks for the
Beginning Call Date. When I now type in the date (the same way I
always have) I now get an error that states "This expression is typed
incorrectly, or is too complex to be evaluated....".
The data for the report is called using an embedded querie that I
built using the SQL Statement Query Builder. The following is the SQL
statement for the Querie:
SELECT [COURSE_ CALENDAR].Course_Start_Date, [COURSE_
CALENDAR].[2_ltr_Course_Code], [COURSE_ CALENDAR].Course_Airport,
[COURSE_ DESCRIPTION].Week_Long_Designation, [COURSE_
CALENDAR].COURSE_CAN, COMPANY.[Company Name], COMPANY.Address,
COMPANY.City, COMPANY.State, COMPANY.Phone, [ORDERS_ DETAILS].ID,
[ORDERS_ DETAILS].Registration_Date, [ORDERS_ DETAILS].First_Name,
[ORDERS_ DETAILS].Last_Name, [ORDERS_ DETAILS].License_1, [ORDERS_
DETAILS].Amount_Paid, [ORDERS_ DETAILS].Install_2, [ORDERS_
DETAILS].Install_3, [ORDERS_ DETAILS].Install_4, [ORDERS_
DETAILS].Date_Paid, [ORDERS_ DETAILS].TC_Amount, [ORDERS_
DETAILS].TC_Type, [ORDERS_ DETAILS].Shipping, [ORDERS_ DETAILS].Tax,
[Tax]+[Shipping] AS [T & S],
[Amount_Paid]+[Install_2]+[Install_3]+[Install_4] AS Payments,
[Costo]+[bkcosto]+[T & S]-[TC_Amount] AS Total_Due, [ORDERS_
DETAILS].REG_CANCEL, [ORDERS_ DETAILS].Bkcosto, [ORDERS_
DETAILS].COSTO, [COURSE_ DESCRIPTION].Course_order, HOTELS.HOTEL_NAME,
HOTELS.HOTEL_ADDR, HOTELS.HOTEL_CITY, HOTELS.HOTEL_STATE,
HOTELS.HOTEL_ZIP, HOTELS.HOTEL_TEL, HOTELS.HOTEL_CONTACT,
HOTELS.HOTEL_FAX FROM HOTELS INNER JOIN ([COURSE_ DESCRIPTION] INNER
JOIN ([COURSE_ CALENDAR] INNER JOIN (COMPANY INNER JOIN [ORDERS_
DETAILS] ON COMPANY.Phone = [ORDERS_ DETAILS].Phone) ON [COURSE_
CALENDAR].ID = [ORDERS_ DETAILS].COURSE_CALENDAR_ID) ON [COURSE_
DESCRIPTION].ID = [COURSE_ CALENDAR].COURSE_DESCRIPTION_ID) ON
HOTELS.ID = [COURSE_ CALENDAR].HOTELS_ID WHERE ((([COURSE_
CALENDAR].Course_Start_Date)>=[forms]![ReportRange3]![Beginning Call
Date]) AND (([COURSE_ DESCRIPTION].Week_Long_Designation)<>"exam
prep"));
The criteria for the Course_Start_Date (from the first line of the SQL
statement) is:
I have a dozen reports built using the same technique, so I would
appreciate any fixes for the current problem as well as thoughts as to
why it happened in the first place in case it happens again.
Also, the querie works when I run it from the SQL builder.
Thanks.