I have a report that needs to have a max number of entries as shown below is it possible to have access put items in until line 30 then continue in the columns to the right?
Serial No. No. of the item Origin Obsevations Serial No. No. of the item Origin Obsevations 1 12345 Kansas Closed 31 12375 Cottonwood Pending 2 12346 New York Closed 32 12376 Dewey-Humboldt Pending 3 12347 Washington Closed 33 12377 Douglas Closed 4 12348 Bullhead City Pending 34 12378 Duncan Pending 5 12349 Chandler Closed 35 12379 Eagar Pending 6 12350 Flagstaff Closed 36 12380 El Mirage Pending 7 12351 Globe Closed 37 12381 Eloy Pending 8 12352 Lake Havasu City Closed 38 12382 Flagstaff[b] Pending 9 12353 Mesa Closed 39 12383 Florence[b] Closed 10 12354 Nogales Closed 40 12384 Fountain Hills Pending 11 12355 Phoenix Closed 41 12385 Fredonia Pending 12 12356 Scottsdale Closed 42 12386 Gila Bend Pending 13 12357 Tempe Closed 43 12387 Gilbert Pending 14 12358 Tucson Closed 44 12388 Glendale Pending 15 12359 Apache Junction Closed 45 12389 Globe[b] Pending 16 12360 Avondale Pending 46 12390 Goodyear Pending 17 12361 Benson Closed 47 12391 Guadalupe Pending 18 12362 Bisbee[b] Closed 48 12392 Hayden Pending 19 12363 Buckeye Closed 49 12393 Holbrook[b] Closed 20 12364 Bullhead City Closed 50 12394 Huachuca City Pending 21 12365 Camp Verde Closed 51 12395 Jerome Pending 22 12366 Carefree Closed 52 12396 Kearny Pending 23 12367 Casa Grande Closed 53 12397 Kingman[b] Pending 24 12368 Cave Creek Pending 54 12398 Lake Havasu City Pending 25 12369 Chandler Closed 55 12399 Litchfield Park Closed 26 12370 Chino Valley Closed 56 12400 Mammoth Pending 27 12371 Clarkdale Closed 57 12401 Marana Pending 28 12372 Clifton[b] Closed 58 12402 Maricopa Pending 29 12373 Colorado City Closed 59 12403 Mesa Pending 30 12374 Coolidge Closed 60 12404 Miami Pending