Autonumber and Sort based creteria

[gstylianou]

Hello,

I would like your help with sorting the data in Table 1. As you will see, each record is registered in a certain category [Group] and at a certain time [xTime]. The point is:

Based on the registration time and the category, I would like the [txtSequent] field to be updated with a number starting from 1 and a serial number depending on the specific registrations in the category.

In order to fully understand exactly what the field number [txtSequent] must be, I have already entered some numbers

I would appreciate your help.

 

[arnelgp]

please check if this is what you have in mind.

 

[gstylianou]

please check if this is what you have in mind.

Hello arnelgp and thank you very much.

Your example database is exactly what i wanted but is it possible to do the same work using a command button? It would be more usable for my case.

thanks again