Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show first 30 values in field1, next 30 in field2, next 30 in field1

Status
Not open for further replies.

legos

Programmer
Joined
Jul 2, 2003
Messages
151
Location
US
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
 
Build a report based on your query and go to Design View. HIt Page Setup and use the Columns tab to get your snaking cols. then size the height of the textboxes to get 30 lines per page.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top