No Current Record Error 3

[jadams0173]

I added a field to my query and now it says NO Current record when I try to run it. If I remove the field it runs fine. The field is a yes/no checkbox.

SELECT J.JobNumber, J.PreReq, T.CourseNo, T.EmpNo, Max(T.CourseDate) AS TakenOn, [red]T.Disqualified[/red], tblSubCourse.SubCourseName, tblSubCourse.ExpirationInMonths, Max(CDate(Format(IIf(IsNull(T.EmpNo),#1/1/1900#,IIf([ExpirationInMonths]=0,#12/31/2099#,DateAdd("m",CInt(([expirationInMonths])),[coursedate]))),"mm/dd/yyyy"))) AS ExpireDate
FROM (tblJobReq AS J LEFT JOIN [SELECT * FROM TblTrainingRecords WHERE EmpNo='12345' ]. AS T ON J.PreReq = T.CourseNo) LEFT JOIN tblSubCourse ON J.PreReq = tblSubCourse.SubCourseNumber
WHERE (((J.JobNumber)='100'))
GROUP BY J.JobNumber, J.PreReq, T.CourseNo, T.EmpNo, [red]T.Disqualified[/red], tblSubCourse.SubCourseName, tblSubCourse.ExpirationInMonths;

Any ideas.





I tried to have patience but it took to long! -DW

 

[jadams0173]

I'll give it a go Alex and see what happens.

Yes the patience is running a little thin today.

I tried to have patience but it took to long! -DW

 

[jadams0173]

That did the trick!!!



I tried to have patience but it took to long! -DW

 

[AlexCuse]

Excellent! Glad you got it to work, it was starting to drive me nuts!

Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.