Help Writing an Expression

[Blackhaus]

Hi gang, I'm an Access rookie with a problem. I have a table with three columns and I need to create a result field which will "count" the number of occurences of a value in the "CustNum" field. (There are other columns in the table as well so I can't use a "count" function) Please see my simulated results in the "Count" column. I'd like to have a query create this expression. Any help? Thanks! Sorry for the formatting, not sure how to replicate a table in my post.



CustNum First Last Count
9891247372 KURT FENCHEL 1
9891247372 KURT FENCHEL 2
9891247412 GRIEG MOORE 1
9891247412 GRIEG MOORE 2
9891247412 GRIEG MOORE 3
9891247414 John Verwey 1
161243818 DANILO LAMBO 1
9891247198 MICHAEL SAUNDERS 1
9891247211 CATHLEEN DELANOY 1
9891247211 CATHLEEN DELANOY 2
9891247211 CATHLEEN DELANOY 3
9891247211 CATHLEEN DELANOY 4
9891247211 CATHLEEN DELANOY 5

 

[kidrobot]

count: count(*)


will that work?

 

[Blackhaus]

Where do I put that? I'll try.