Count of Records

[Portucale]

Hi,

I am looking to achieve a column within a query which gives me the count of records that are equal to a string in a different field, e.g.

Field1 Count
aaa21 3
aab01 2
aaa21 3
aaa21 3
aab01 2

Any help and all the help is very much appreciated.

Kind regards,

 

[namliam]

Select yourfield, count(yourfield) from yourtable group by yourfield

 

[plog]

...that are equal to a string in a different field,

Huh? Please post sample starting data that demonstrates the results you have already posted. Include field and table names.