Results 1 to 9 of 9
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839

    Numbers with sub counts

    How could I set up a numbering system where you have a main number and then have a choice of a sub number? Ie:

    Main = 1
    Sub = 1.01

    But still be able to move on to 2. Would I need a routine to ask if the next number is a sub number?

    thanks

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    What are you trying to achieve with this method?

    What is the purpose of the numbering system?

    What is the function of the numbering system?

  3. #3
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Can you explain in a little more detail what you are doing? Are you Invoicing with something like a ReBill Option?
    What is Main? Can't really tell from the vague description but I would think you would need a ComboBox with Options.

  4. #4
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    it is like a repair order systems

    Main is the main repair order and each line added to the main number would be a sub of the number.

    1
    1.01
    1.02
    2
    3
    4
    5.01
    5.02..........

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This is generating a custom unique identifier. Common topic. Search forum.
    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.

  6. #6
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    As June said, with a little effort in a search, you can perhaps find what you want. That said, here is an Example that may get you started.


    If IsNull(IncrementedCounter) Then
    [EndResult] = (0.01 * DCount("[IncrementedCounterField]", "SomeTable", "[PrimaryKey] = " & Forms!SomeForm!PrimaryKey))
    End If
    Good Luck!

  7. #7
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    Thanks gents, much appreciated. Please understand us newbies to the craft don't know what to search for. I know its a PITA for the oldtimers to answer the same questions repeatedly.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Search the forum on keywords: "custom unique identifier".

    Can further narrow the search if you reference user "June7". I have responded in a LOT of threads on this topic.
    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.

  9. #9
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    Thanks all, but I found a simpler way (for me)
    I made a field - Sub_Number

    I placed the following in a column in the query on the report.
    Sub_CRs: CR_Number + Sub_Number*.01

    It allows the user to input the integer as needed to add to the CR_Number. I didn't make it fully automated since you would always need a popup asking if the current input is a Main or Sub CR. Works like a charm.

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

Similar Threads

  1. Replies: 8
    Last Post: 03-10-2014, 11:47 AM
  2. Why Are Counts Different?
    By johnywhy in forum Queries
    Replies: 9
    Last Post: 01-08-2014, 05:35 PM
  3. Query - Counts
    By maxx102 in forum Access
    Replies: 1
    Last Post: 12-14-2012, 12:49 PM
  4. too many counts!
    By Svear in forum Access
    Replies: 1
    Last Post: 03-07-2012, 10:14 PM
  5. Replies: 1
    Last Post: 11-29-2011, 08:43 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