SQL Question - Select most recent record

[psycoperl]

I have two yes/no boxes (ReceivedOnATBEligible and NotATBeligible), what I need to do is modify my query which is below, to pull the most recent record with either ReceivedOnATBEligible or NotATBEligible for the specific StudentID. As there could be other records without either of the flags I can not just pull the most recent comment record.

Thanks for your assistance

 Sql_Query = "SELECT TOP 1 CommentDate, " & _
            "ReceivedOnATBEligible, NotATBeligible " & _
            "FROM tblComments " & _
            "WHERE (((StudentID)='" & StudentID & "'))" & _
            "ORDER BY CommentDate DESC;"

 

[Norie]

Can't you just add that to the criteria?

" WHERE (StudentID='" & StudentID) & "' AND (ReceivedOnATBEligible And NotAtEligible) "

That shoud return all the records that match StudentID and also have either ReceivedOnATBEligible or NotAtEligible true.

I think that's what you want.

 

[psycoperl]

Can't you just add that to the criteria?

" WHERE (StudentID='" & StudentID) & "' AND (ReceivedOnATBEligible And NotAtEligible) "

That shoud return all the records that match StudentID and also have either ReceivedOnATBEligible or NotAtEligible true.

I think that's what you want.

Thank you that is what I was leaning towards, but was not sure on how to code the condition with the YES/NO boxes.

I just made it "AND (ReceivedOnATBEligible OR NotAtbEligible) "