Sorry for what is probably a simple question but I am having problems.

I have a query which is just returning records that have a 'Location Code'
of STHT.  In each record is an ID number of a person.  Each person can have
multiple records in the query.  I want to add a new column to the query that
counts how many times the ID number (within that record) appears in the
entire query.

I have used the expression builder to do the following but it just counts
the total number of ID numbers in the entire query.

IDCount: DCount("[ID_NO]","[STHT]","[ID_NO]")

I think I somehow need to specify that the criteria only uses the particular
ID number from the record being calculated.

I am very limited with Access so please go easy on me.  This is my last
attempt at trying to make friends with Access after which I will ignore its
existance and just use Excel!!!

Any assistance would be greatly appreciated.

Cheers

Paul