show duplicate sequence

  • Thread starter Thread starter guy
  • Start date Start date
G

guy

i simplify my table as follows, to which field2 needs to be inserted, based
on the sequence of duplicate field1. but i have no idea how to do it...
Thanks for reply!!

______________
field1 field2
______________
a 1
a 2
a 3
b 1
c 1
c 2
d 1
d 2
e 3
.. .
.. .
 
revised table...
______________
field1 field2
______________
a 1
a 2
a 3
b 1
c 1
c 2
d 1
d 2
d 3
.. .
.. .
 
i simplify my table as follows, to which field2 needs to be inserted, based
on the sequence of duplicate field1. but i have no idea how to do it...
Thanks for reply!!

______________
field1 field2
______________
a 1
a 2
a 3
b 1
c 1
c 2
d 1
d 2
e 3
. .
. .
Click to expand...

I would recommend that Field2 should be calculated as needed, not stored in
the table. If you were to add a new a record, you'ld need to recalculate
anyway!

Is there some *other* field which can be used to define a sort order? Access
won't be able to distinguish the three "a" records from one another, so there
will be no simple way to say that *this* one is number 1, and *that* one
number 3.

Could you explain the real-life problem you're trying to solve? There may be a
better way!

John W. Vinson [MVP]
 
Back
Top