searching access database

[mooe]

Hello,

I have an access database with 100,000+ records that I need to search through. I only need to work with the records that have a value in the account number field. Right now I have it going down the table and whenever it finds a row with an account number in it, it does the computations. This process only allows a few hundred records to be done every minute. I need to speed this up, but I have no clue how. Any help would really help me out

For i = 1000 To x 'x is number of rows in table

    
    
    Adodc1.RecordSource = "SELECT * FROM tSaleTransactions Where cdeTrans='A" & i & "'"
  
    Adodc1.Refresh
  
    If Adodc1.Recordset.Fields("cdeCustCode") <> Empty Then
'does computations