have a list of numbers in access and I want to show them in a special way

[CJ_London]

rpeare's code or June's code could be modified to do the job.

mine already does

How many rows (shaded boxes) are on a printed page???

I believe 60 - 4 columns x 15 rows per post #6 One page fits 60 serial number or row.

[ssanfu]

@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

One page fits 60 serial number or row.

In the report page there are 4 columns and 60 cards,
let's say that there are 6000 serial number or rows, divide the 6000 serial number on 60 cards per page it will be 100 pages.

OP says 4 columns.
But then

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...

Now OP shows 3 columns..???


My example, Post #10, shows 3 columns and the OP says that is what he wants.

I am sooooooooooo confused............

[CJ_London]

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

[amran88]

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.

[CJ_London]

If anyone do this, please attach the access file that you worked on

in my case, no need, just copy and paste the code as supplied

[amran88]

in my case, no need, just copy and paste the code as supplied

sorry but It did not work like I wanted.

[CJ_London]

OK - I clearly don't understand what you require so I'll drop off this thread

good luck with your project

[ssanfu]

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???

[CJ_London]

@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

[ssanfu]

@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.

[CJ_London]

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

[ssanfu]

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.....

[CJ_London]

phew - thought it was me

[amran88]

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???

yes yes this is exactly what i need, please attach the access file.

thank you very much