Solved How to make count series record 1 2 3 . . [SubForm]

[SalmanZeiad]

View attachment 84258

 

[CJ_London]

Your example does not go far enough - is row 1 always 1, regardless of order of the records, or is there a meaning to it based on for example the order of dates or other value.

i.e. from this
Value Row
A............1
B............2
C............3

do you want
Value Row
C............3
B............2
A............1

or

Value Row
C............1
B............2
A............3

 

[arnelgp]

add Autonumber (ID) to your table.

create a Query to generate the serials:

select field1, dcount("1", "yourTable", "ID<=" & [ID]) as Seqn from yourTable Order by 2 Asc;

use this Query as the recordsource of your form.

 

[SalmanZeiad]

add Autonumber (ID) to your table.

create a Query to generate the serials:

select field1, dcount("1", "yourTable", "ID<=" & [ID]) as Seqn from yourTable Order by 2 Asc;

use this Query as the recordsource of your form.

CAN YOU MAKE IT PLZ..

 

[SalmanZeiad]

Your example does not go far enough - is row 1 always 1, regardless of order of the records, or is there a meaning to it based on for example the order of dates or other value.

i.e. from this
Value Row
A............1
B............2
C............3

do you want
Value Row
C............3
B............2
A............1

or

Value Row
C............1
B............2
A............3

NO

 

[CJ_London]

two choices of answer - so no idea what 'no' means

 

[arnelgp]

see this sample.

 

[SalmanZeiad]

see this sample.

Wow Wow Wow
thank you alot