Results 1 to 4 of 4
  1. #1
    stanley721 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    32

    Numbering with added text to it


    I have a report that is based on a query. It is used to write tests. So I populate a table with a certain number of questions and the report basically makes a test with the questions numbered. In the past I've used the =1 and it does what I want. But now I have multiple test numbers and I want that text or test number to appear before the question number as follows: "3-1." , "3-2." , and so on. Without just adding a simple text box in front of the other text box with the =1 int it, is there a better way. Every time I've tried what I've found out there from microsoft, it came up blank or gave me a syntax error. I hope all that makes sense.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Not understanding why what you've been doing no longer serves. Do you want the question sequence number to start over for each test number? Possibly set up a test number group section and do the sequence number over the group.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    stanley721 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    32
    I may have 9 or 10 or 100 questions. If I put 2 text boxes side-by-side, the spacing sometimes becomes an issue (3-1. or 3- 1.), depending on how many test questions are included. So to make it standard all the time, I would like for all the info in one box. It is mainly just a formatting issue, wanting it to look neat.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Could do the sequence count in one textbox (can be hidden) then in another textbox concatenate the sequence with the test number.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Numbering Records
    By George in forum Access
    Replies: 6
    Last Post: 10-21-2013, 04:42 AM
  2. Help with numbering
    By hudsonp in forum Access
    Replies: 3
    Last Post: 11-21-2012, 08:55 AM
  3. added text to entire column in the Query
    By Jerseynjphillypa in forum Queries
    Replies: 3
    Last Post: 06-12-2012, 09:39 AM
  4. Page numbering
    By gumberculies in forum Reports
    Replies: 1
    Last Post: 04-11-2011, 02:21 PM
  5. Numbering records
    By knightjp in forum Database Design
    Replies: 0
    Last Post: 08-17-2008, 07:07 AM

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