Substitute Of Last() Of Ms Acces 2000 in Sql Server 2000

[aschauhan18]

Hi

Does Anybody help me
Substitute Of Last() Function Of Ms Acces 2000 in Sql Server 2000 .

This is my query
-----------------------------------------------------------------------------------------
Select * from AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "' AND MOut=(Select Last(MOut) From AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "')")
=============== =============== =============== ===========
this is writtin in Visual basic as frontend here <date> is todays date and
MDate : is date of in
MOut : time
=============== =============== ===========
plz do me help

[voroojak]

i am not sure but i think u can use max() instear of last().

[achhabra]

The same problem I m facing, have u got any solution of the same, if yes thn plz let knw the same,

Hi

Does Anybody help me
Substitute Of Last() Function Of Ms Acces 2000 in Sql Server 2000 .

This is my query
-----------------------------------------------------------------------------------------
Select * from AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "' AND MOut=(Select Last(MOut) From AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "')")
=============== =============== =============== ===========
this is writtin in Visual basic as frontend here <date> is todays date and
MDate : is date of in
MOut : time
=============== =============== ===========
plz do me help

[ck9663]

Hi

Does Anybody help me
Substitute Of Last() Function Of Ms Acces 2000 in Sql Server 2000 .

This is my query
-----------------------------------------------------------------------------------------
Select * from AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "' AND MOut=(Select Last(MOut) From AG_IN_OUT_Local where CARDID='" & StrNo & "' and mdate between '" & DateValue(Date) & "' and '" & DateValue(DateA dd("h", -1, MDate)) & "')")
=============== =============== =============== ===========
this is writtin in Visual basic as frontend here <date> is todays date and
MDate : is date of in
MOut : time
=============== =============== ===========
plz do me help

Is it the same as MAX or MIN ?

-- CK