Hello there, I would like to have an advice from you guys, please check the enclosed file and let me know if this is possible:
As you can see I have two records and 3 orders, 2 orders for the record 1 and one order for the record two, is possible to add a field that count a new record starting in 1?
for instance if I have 3 record, the first one have 5 orders, second 7 orders and third 4 orders, I would like to see the subform like this:
OrderID Consecutive Order Date
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5
2 6
2 7
3 1
3 2
3 3
3 4
thanks in advance for any response
As you can see I have two records and 3 orders, 2 orders for the record 1 and one order for the record two, is possible to add a field that count a new record starting in 1?
for instance if I have 3 record, the first one have 5 orders, second 7 orders and third 4 orders, I would like to see the subform like this:
OrderID Consecutive Order Date
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5
2 6
2 7
3 1
3 2
3 3
3 4
thanks in advance for any response