Count Needed When Fields are Equal 2

[ineedyourhelp]

I have two fields in my Master Table...

User ID
Completed By

Both of these fields are formatted as Memo and contain names.
I am trying to structure a query that will give me a count where the User ID field and the Completed By field contain the same name. (User Id = Completed By)

Any help would be appreciated.

 

[amorous]

Does this work

Select [User ID], [Completed By], Count(*) AS totalCompleted from yourtable Group By [User ID],[Completed By]

-VJ

 

[PHV]

Something like this?
SELECT [User ID], Count(*)
FROM theTable
WHERE [User ID]=[Completed By]
GROUP BY [User ID]
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244