Retrieving data frm ms access

[Alv45525]

hello guys, i really need help....i have a transaction table in ms access N i want to retrieve last 10 transaction from the table from my vb form...how am i suppose to do it???i used the folloing code but it is displaying all transactions of a specific account number. N i just need the last ten. Plz gimme some ideas.

   Private Sub btnClick_Transactions_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClick_Transactions.Click
        Dim BalConn As OleDb.OleDbConnection
        Dim dsBal As DataSet

        BalConn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database\VB.net.mdb")
        Dim strSQL As String
        dsBal = New DataSet

        strSQL = "select * from tbl_Transactions where Account_Number='" & UserAccGlobal_Login & "'"

        Try

            BalConn.Open()
            Dim daMyAdapter = New OleDb.OleDbDataAdapter(strSQL, BalConn)
            daMyAdapter.Fill(dsBal, "Account_Number")

            datTransactions_Grid.DataSource = dsBal
            datTransactions_Grid.DataMember = "Account_Number"

        Catch ex As Exception

            MessageBox.Show(ex.Message, "Exception Raised")

        Finally
            BalConn.Close()

        End Try
    End Sub


    Private Sub frmTransactions_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing

        ClosingTransaction.Enabled = True

    End Sub

[jquick]

Change your code to this:

strSQL = "select top 10 from tbl_Transactions where Account_Number='" & UserAccGlobal_Login & "'"

[Alv45525]

thx for rply but it does not work:
it says:
the SELECT statement includes a reserved word or argument name that is misspelled or missing, or punctuation is incorrect.

[jquick]

Hello,

Sorry it should be "SELECT TOP 10 *"

Give that a shot.

Jenni

[Alv45525]

it works but the problem is that i need the last ten records added. And the code above selects the top 10 from my table.

[jquick]

If you need the last ten records updated you'll have to sort by some column; ideally a DateTime field. If there is a primary key field you can use that too. For example if u had a column called "DateAdded" just add this:

"SELECT * FROM TABLE
ORDER BY DateAdded DESC"

The DESC is descending order. If that is the opposite of what you need then use ASC (ascending).

[Alv45525]

I tried something like
"SELECT TOP 10* FROM Table ORDER BY DateAdded DESC.......but is
not working either.

[Alv45525]

Hey thx a lot for yur help...i got the solution.
ThanX