create a counter

F

Fasiano

If you please could help me i will be very glad.
this is what i have:
StudentID Class Date
S031N0032 EENG-122 1/1/2007
S031N0032 EENG-122 3/5/2007
S031N0032 EENG-122 6/7/2007
S022N0012 EENG-443 3/2/2005

This is what i want:
StudentID Class Date Counter
S031N0032 EENG-122 1/1/2007 1
S031N0032 EENG-122 3/5/2007 2
S031N0032 EENG-122 6/7/2007 3
S022N0012 EENG-443 3/2/2005 1

When the combination of StudentID and Class change(either of two changes),
the counter should start from 1.
Thank you
 
E

Evan Camilleri

you'd have to do it via vba-code. do you have any idea of vba coding?

where are you entering these records.... in a form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
pieces picked per hour 0
Creating Different Headers in Word 0
Match 2 Columns and Add the Values of Third Column 0
Making a macro only work on certain files 2
Arriving at totals 2
Auto picking numbers 5
List all tables, including document structure 0

Top