i have two fields, time and depth in a table. i need to make a query based on these fields.
what i need to do is display pairs 1-30 in field1 and 2, 31-60 in field3 and 4, 61-90 in field1 and 2, 91-120 in field2 and 3 and so on.
however i do not want it to look like this: t=time d=depth
t1 d1
t2 d2
t3 d3
t4 d4
t5 d5
t6 d6
t7 d7
t8 d8
t9 d9
i want it to look like this:
t1 d1 t4 d4
t2 d2 t5 d5
t3 d3 t6 d6
The time field values are in incriments of 5 starting from 0. (so the first value is zero, and the 11th value is 50) The depth value has no interval, but the value always increases. the time value does get large,(in the thousands) so i would prefer not haveing to use any statements that use a number bound to display the valuse, but i will if i have to.
Durible Outer Casing to Prevent Fall-Apart
what i need to do is display pairs 1-30 in field1 and 2, 31-60 in field3 and 4, 61-90 in field1 and 2, 91-120 in field2 and 3 and so on.
however i do not want it to look like this: t=time d=depth
t1 d1
t2 d2
t3 d3
t4 d4
t5 d5
t6 d6
t7 d7
t8 d8
t9 d9
i want it to look like this:
t1 d1 t4 d4
t2 d2 t5 d5
t3 d3 t6 d6
The time field values are in incriments of 5 starting from 0. (so the first value is zero, and the 11th value is 50) The depth value has no interval, but the value always increases. the time value does get large,(in the thousands) so i would prefer not haveing to use any statements that use a number bound to display the valuse, but i will if i have to.
Durible Outer Casing to Prevent Fall-Apart