Is there a formula or easy way to add a record counter in Access to a
query?
I have a field that contains a file number this file. I want to add a
counter like below.
Field Name Field Name (B)
FileNumber ElCounter
9565845 1
9565845 2
9552456 1
9552456 2
9552456 3
5695695 1
5695695 2
5695695 3
5695695 4
5695695 5
Thanks for your assistance.
Sam