The results for that query are:
ADMIN 6
CSR 21
OGC 276
TM 48
>Can you run one more query and post result?
>
SELECT OutbackLogin.OLUserType, COUNT(*)
>FROM OutbackLogin
>GROUP BY 1
>
>>When I run the query below it just returns this:
>>
>>OGC 10072 10590
>>
>>>Can you just cut and paste those two lines?
>>>
>>>>I would, but there is a total of 278 records that it returns from the table whenever I run the query.
>>>>
>>>>>Can you post results for CSR and ADMIN usertypes? Just copy it from QA result window.
>>>>>
>>>>>>I ran your code in a query and the results return where that the minimum number was 10072 and the maximum number was 10590
>>>>>>
>>>>>>>In this case something wrong in your logic. Run following select to see Id ranges for each usertype.
SELECT OutbackLogin.OLUserType, MIN(OGC.OGCID), MAX(OGC.OGCID)
>>>>>>>from OGC inner join OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
>>>>>>>GROUP BY 1
>>>>>>>
>>>>>< snip >