Hi All,
I am new to ACCESS & to this forum.
I have a problem (please see table below & attachment)
DOC1 shows three columns, Dept column is in ascending order, what I want to do is add a numbering column like DOC2 to identify individual dept lines.
please can you tell me if that is possible
DOC1
Dept Subdept Amount
AAA A1 75
AAA A3 45
AAA A2 13
BBB B2 16
BBB B1 4
CCC C2 22
CCC C1 20
CCC C3 15
DOC2
No Dept Subdept Amount
1 AAA A1 75
2 AAA A3 45
3 AAA A2 13
1 BBB B2 16
2 BBB B1 4
1 CCC C2 22
2 CCC C1 20
3 CCC C3 15
Thanks for your help