This is what I have ( it is just the SQL part of the VBA). I woud l like to be able to Look up all my values in Column A in Access database and return additional information how would I do that?
Set db = OpenDatabase(Dbloc)
SQL = SQL & "SELECT Date" & " "
SQL = SQL & "FROM " & " Deduction" & " "
SQL = SQL & "WHERE Payment = '6754238' "
Set rs = db.OpenRecordset (SQL, dbOpenSnapshot)
Set db = OpenDatabase(Dbloc)
SQL = SQL & "SELECT Date" & " "
SQL = SQL & "FROM " & " Deduction" & " "
SQL = SQL & "WHERE Payment = '6754238' "
Set rs = db.OpenRecordset (SQL, dbOpenSnapshot)