mine already doesrpeare's code or June's code could be modified to do the job.
I believe 60 - 4 columns x 15 rows per post #6 One page fits 60 serial number or row.How many rows (shaded boxes) are on a printed page???
mine already doesrpeare's code or June's code could be modified to do the job.
I believe 60 - 4 columns x 15 rows per post #6 One page fits 60 serial number or row.How many rows (shaded boxes) are on a printed page???
@Ajax,
Sorry....I missed your post - I didn't refresh before posting - had several interruptions while composing....
Not sure whether the OP wants 3 columns or 4 on the report.
From post #6
OP says 4 columns.
But then
Now OP shows 3 columns..???What I want from the report is from page 1 starting from serial number 1, 2, 3. Page 2 serial number 4,5,6 and page 3 serial number 7,8,9 to page 100 serial number 298,299,300.
and return to page 1 after serial number 3 continue from the last serial number on page 100 serial number 301, 302, 303 and continue like this to page 100 and go back to page 1...
My example, Post #10, shows 3 columns and the OP says that is what he wants.
I am sooooooooooo confused............
OP hasn't responded for 3 days although there were on the forum yesterday. But most of the solutions have been in the last 24 hours - Guess they've lost interest
Hi every one and thank you for the attention,
am trying everything you post.
ssanfuthe dimensions of the dark box(width 8.6 cm, Height 1.801 cm) there is 60 shaded boxes per page, 4 columns, every column have 15 shaded boxes.
i am printing 60 serial numbers per page,but with the data sorted as it is, the first page column 1 would have serial numbers 1,2,3,4 to 15, second column serial numbers 16,17,18,19 to 30, etc,,,,third column, Fourth column to serial numbers 60 etc.
the second page would have serial numbers: 61,62,63,64 to 120 etc
but this isn't what i need when i cut the boxes up, i need the resulting stacks to be in numerical order. Hence i need first page column 1 boxes with serial numbers 1,2,3. second page column 1 boxes with serial numbers 4,5,6 etc
I need the report to calculate the number of serial numbers and then divide the number of serial numbers on the number of boxes is 60, so we get the number of pages.
let's say that we have 6000 serial number divided by 60 boxes will be 100 pages,
the report will inform on page 100 column number 1 serial number 300 returns to page 1 column number 1 and puts the 3 serial numbers 301,302,303, Page 2 column number 1 serial number 304,305,306 etc, till Fill column 1 on each of the 100 pages.
Then start from page 1 column number 2 serial number 1501,1502,1503, page 2 column number 2 serial number 1504,150,5,1506, etc.
If anyone do this, please attach the access file that you worked on, I am very appreciative of all the effort
thank you.
in my case, no need, just copy and paste the code as suppliedIf anyone do this, please attach the access file that you worked on
sorry but It did not work like I wanted.in my case, no need, just copy and paste the code as supplied
OK - I clearly don't understand what you require so I'll drop off this thread
good luck with your project
OK, I finally got Ajax's queries to work - the table is named "admCounter" and the first query should be named "admCount" (not admCounter).
But the query is missing a few page numbers - didn't see a page 1 (that I could find).
I slightly modified the code by rpeare (Post #13). I am still not sure whether you want 3 columns or 4, so I picked 4 columns and 15 rows.
I created 6000 serial numbers. Here are images of the first 2 report pages.
Is this what you want???
@Steve - not sure why you had a problem. If you created a table rather than using the counter query so be it - but the page number is there, field is called page - this is a snapshot of the first few rows. There should be no need to sort it since that is done in the report
NUMBER1 Serial_Number rcount rows cols pages page rownum col SortOrder 3553 5657 8952 3146 1 6000 15 4 100 1 1 1 1011 3553 5657 8952 3146 2 6000 15 4 100 1 1 2 1012 3553 5657 8952 3146 3 6000 15 4 100 1 1 3 1013 3553 5657 8952 3146 4 6000 15 4 100 1 1 4 1014 3553 5657 8952 3146 401 6000 15 4 100 1 2 1 1021 3553 5657 8952 3146 402 6000 15 4 100 1 2 2 1022 3553 5657 8952 3146 403 6000 15 4 100 1 2 3 1023 3553 5657 8952 3146 404 6000 15 4 100 1 2 4 1024
Anyway, OP seems ungrateful given their lack of clarity of requirement and seems they want someone to do the whole thing
@Ajax - Queries are not my strong suit; I'm better at coding. I am ok with some queries: nested queries and queries built on queries.
But I look at the queries you develop and sometimes have to shake my head - I could not develop most of the queries you post. they are amazing. So I try and learn from you.
I tried to follow your post:
I created the table as instructed (admCounter - 1 field, 9 records), created (pasted ) the first query (admCount), then pasted the 2nd query (query1).
I created a report with the 2nd query (query1) as the report record source and did the sorting in the report.
Could not find a serial number with a page 1.
I'll have to go over it again.
I did edit the second query about 10 mins after posting- realised I had left a bit of a mix between 3 and 4 columns in the second query
but you are right, re the first query i said save it as admCounter, should have been admCount. Just tried to edit the post to correct it but now out of edit time
Did notice you say 'I created the table as instructed (admCounter - 1 field, 9 records)'. should be 10 records - 0-9
DOH!! I should learn how to read first.
I added 10 records (0 - 9) and the result is what you posted.
The VBA code executes in approx 40 secs and your query executes < 1 sec.
OK, I have a lot of studying to do.....
phew - thought it was me
yes yes this is exactly what i need, please attach the access file.OK, I finally got Ajax's queries to work - the table is named "admCounter" and the first query should be named "admCount" (not admCounter).
But the query is missing a few page numbers - didn't see a page 1 (that I could find).
I slightly modified the code by rpeare (Post #13). I am still not sure whether you want 3 columns or 4, so I picked 4 columns and 15 rows.
I created 6000 serial numbers. Here are images of the first 2 report pages.
Is this what you want???
thank you very much