!!!!!ACCESS2000 GRIDLOCK!!!!!!!!

[20002000]

I BUILT AN APPLICATION IN ACCESS97 WHICH WORKED FINE. ON TRYING TO INSTALL IT AND CONVERT TO ACCESS2000 I REALISED THAT SOME OF THE MODULES THAT I BUILT WITH SQL QUERIES DONT WORK IN ACCESS2000.ESPECIALLY THE ONES CARRYING OUT DATE MANIPULATION. E.G I THIS FOR A QUERY AND BUILT A MACRO BASED ON THE QUERY, THEN FROM A COMMAND BUTTON THE MACRO IS RUN WHRN THE BUTTON IS CLICKED. IN ACCESS 97 WHEN IT IS CLICKED THE USER IS PROMPTED FOR THE TUTOR NAME,WEEK STARTING VALUE AND WEEK ENDING VALUE WHICH ARE DATES, AND A REPORT PREVIEW BASED ON THE VALUES IS DISPLAYED.
HOWEVER WHEN THIS IS TRIED IN ACCESS 2000 I GET THE MESSAGE THAT EXPRESSIONMAY BE TOO COMPLEX TO BE EVALUATED.WHY DOES IT WORK IN ACCESS97 AND NOT IN 2000. WHAT CAN i DO? BELOW IS THE QUERY I USE

********************************************************
SELECT TBLLECTURES.[TUTOR_NAME], SUM([LECTURE LENGTH]) AS ['TOTAL LECTURES FOR WEEK'], SUM(TBLLECTURES.[LECTURE LENGTH])*4.00 AS ['£ EARNINGS FOR WEEK']
FROM TBLLECTURES
WHERE TBLLECTURES.[TUTOR_NAME]=[ENTER TUTOR NAME] AND
TBLLECTURES.[DAY] BETWEEN [WEEK STARTING FROM] AND [WEEK ENDING ON:]
GROUP BY TBLLECTURES.[TUTOR_NAME];

 

[tlbroadbent]

Open the query in query designer. Remove part of the query to try to isolate what part of the query is causing the error.

For example, remove the Where clause or the Group By clause and see if the query will run without it. Remove one clause at a time until you find the problem clause(s). Then try recreating that clause. Terry

http://members.home.net/tlbroadbent/index.htm