VBA Count(*) slow in access, SQL pass thru

I've got the following code in my access VB code. It worked fine before I added the round() sectin of the code to round the equasion off to 2 digits. I know the code is correct, i ran it in SQL, it takes 7 seconds to run. I've been waiting for over an hour through access though.. FTY table 1, which is the one rounding, and adding, has about 14,000,000 records, table 2, which its being compared to, has about 100,000,000 records. Public Function GetQueryCount5N() As Long [login to view URL] = 0 Dim rst As [login to view URL] Dim sql As String sql = "SELECT COUNT(*)AS total " _ & "FROM InventorySuppliers INNER JOIN Boyd0315All ON [login to view URL] = [login to view URL] " _ & "WHERE ([login to view URL] = 315) AND ([login to view URL] = 'Y') AND ([login to view URL] = '39%') AND " _ & "(NOT round(([login to view URL] * .61 + 65 + 265)/100,2) = ([login to view URL])) AND (NOT ([login to view URL] = 'E') AND " _ & "NOT ([login to view URL] = 'L') AND NOT ([login to view URL] = 'P'))OR " _ & "([login to view URL] = 315) AND ([login to view URL] = 'Y') AND ([login to view URL] = '39%') " _ & "AND (NOT ([login to view URL] + [login to view URL] + [login to view URL] + [login to view URL] = [login to view URL])) AND (NOT ([login to view URL] = 'E') AND " _ & "NOT ([login to view URL] = 'L') AND NOT ([login to view URL] = 'P'))" Set rst = [login to view URL](sql) With rst If Not .EOF Then GetQueryCount5N = .Fields(0).Value End If .Close End With Set rst = Nothing End Function