Hi, I'm new to this group and fairly new to Access. I have a bunch of
data, and after several other queries, I generate the following query
which has two fields:
Bin, Time
20 3.5
20 3.9
20 4.6
40 2.4
40 2.7
40 3.4
40 5.6
except the real query has about 120 rows, with the first field
(probability bin) taking the values of {20,40,60,80,100} and the second
field (time) taking any real positive number.
For each bin (20 and 40 in the above sample) I want to generate a new
set of data. This data set should consist of the second field (time)
sorted in ascending order, and then an additional field which
increments from 0 to the number of the bin. For example, using the
above sample, I would get the following data:
(For bin=20)
3.5 0
3.9 10
4.6 20
(for bin=40)
2.4 0
2.7 13.3
3.4 26.6
5.6 40
I've had a lot of trouble thinking of some way to do this. Of course
the first step can be to create an intermediate query which only picks
out the numbers from a desired bin, but then I'm still left with
sorting the times and autoincrementing that second field. Thanks for
any tips or suggestions,
-mael