asked on

Running Count of records per emloyees in access query

I am creating an access database query and I need to add a field that will have a running count for each employee.

This is what I have
Gary 1-5-07
Gary 1-12-07
Gary 1-19-07
Jeff 1-12-07
Jeff 1-19-07
Bob 1-5-07
Bob 1-12-07
Bob 1-19-07

and this is what I need:

Gary 1-5-07 1
Gary 1-12-07 2
Gary 1-19-07 3
Jeff 1-12-07 1
Jeff 1-19-07 2
Bob 1-5-07 1
Bob 1-12-07 2
Bob 1-19-07 3

I can't figure out what to do here...

Thanks a lot,
Bonnie

jerryb30

Would any user have two entries for the same date?

SOLUTION

GRayL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bonnie_K

ASKER

Jerryb,

No, the dates are distinct per employee.

I am going to try GrayL's idea now

ASKER CERTIFIED SOLUTION

dbeneit

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GRayL

Do you mean 'Group By' or 'Order By'?

dbeneit

Grayl,
group by , becouse we need only 1 row for each row of table a.

Jeffrey Coachman

Bonnie_K:,

Why not do this in a Report?

Report TextBoxes have a "Running Total" property, that you can set to Over Group or Over All.

So if you grouped your Report by Name you would select "Over Group"
https://filedb.experts-exchange.com/incoming/ee-stuff/2979-Access--Ruuning-GroupTotals.zip

Is this what you wanted?

Jeff Coachman

Bonnie_K

ASKER

Thank you very much,

Bonnie