how to find last enry in table using sql query need help

cmd.CommandText = "SELECT  distinct GLMAST.fglhead,MAINFILE.facno,max(MAINTRAN.fdate) as fdate ,max(MAINTRAN.fbalance) as fbalance  FROM MAINTRAN INNER JOIN MAINFILE ON  MAINFILE.facno like MAINTRAN.facno INNER JOIN MASTERID ON  MAINFILE.fmasterno like MASTERID.fmasterid  INNER JOIN  GLMAST ON GLMAST.fglcode like  LEFT(MAINFILE.facno,9) and   GLMAST.fglhead = '" & ComboBox2.Text & "' and MAINTRAN.fdate<='" & Format(prdate, "MM/dd/yyyy") & "' " & _                                           "where MAINTRAN.fbankcode='" & "010" & "'" & _                                          "and MAINTRAN.fdate<='" & Format(prdate, "MM/dd/yyyy") & "' " & _                                          "and MAINTRAN.fbranchcode='" & "01" & "' group by MAINFILE.facno,GLMAST.fglhead "

Collapse | Copy Code

With cmd
dr = .ExecuteReader
End With

If dr.HasRows = True Then
Do While dr.Read
presentdaybal = dr!fbalance
Loop
dr.Close()

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User11y ago
Without seeing any data it's hard to guide you, but you should be able to select just the entries you need in the query. Or am I misunderstanding your problem?
laxmikant joshi11y ago
i have to show multiple latest entries....
Guest User11y ago
If you only want one specific record, why don't you adjust your query to use ORDER BY and SELECT TOP 1 to return just the row you need?