Results 1 to 2 of 2
  1. #1
    mazinareqe is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2019
    Location
    yemen
    Posts
    1

    help for numbering

    I want to number 90000 passwords on 1500 pages 4 columns each column has 15 numbers in it
    The first number is on the first page, the second number on the second page, and so on, to 100 pages
    Attached Thumbnails Attached Thumbnails Numbering-01-01-01.jpg  

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    look at using the mod and \ operators to specify an order

    you'll need to determine the page, column and row values for each value then sort by these calculated values

    a similar question to this was asked some time ago, but can't find the thread right now

    to get you started, the page number would be calculated as something like

    ((password-1)\3)+1 - the 3 because you want these in groups of 3 per page

    e.g.

    ?((1-1)\3)+1
    1


    ?((2-1)\3)+1
    1


    ?((3-1)\3)+1
    1


    ?((4-1)\3)+1
    2

    edit: you will need to present more realistic data - based on what you are showing 1201 should not be on page 1. You say 4 columns, but are showing 5 and say 1500 pages then 100 pages. All of these will have an impact on what the actual calculation is

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Numbering
    By cfobare79 in forum Reports
    Replies: 3
    Last Post: 04-08-2015, 12:33 PM
  2. Automatic numbering
    By ggrams in forum Access
    Replies: 2
    Last Post: 09-20-2014, 06:52 AM
  3. Invoice Numbering
    By Gatorjunkie in forum Access
    Replies: 1
    Last Post: 03-20-2014, 11:57 PM
  4. numbering a table
    By mikichi in forum Access
    Replies: 6
    Last Post: 01-29-2014, 10:10 AM
  5. Help with numbering
    By hudsonp in forum Access
    Replies: 3
    Last Post: 11-21-2012, 08:55 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums