Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

sequence 1,3,5,7,9

Discussion in 'Information Technology' started by Everett, Jul 28, 2006.

Tags:
  1. Everett

    Everett
    Expand Collapse
    Guest

    I would like to duplicate a formula used in Excel to update a table in
    Access. The Excel formula is from the edit, fill, series and then the step
    values menu. Basically I want to assign a value to the records that counts by
    2 or 3s or what ever value I need.
    So the sequence would be 1,3,5,7,9 and so on. I have a table that has a
    sequence number already but it runs 1,2,3,4,5,6,7 and so on. I would like to
    find a formula that would work off of these values that I already have. Or in
    other words change 1to1 2to3 3to5 4to7 and so on. What’s that formula? Any
    ideas.

    Thanks

    Everett
     
  2. Loading...

    Similar Threads Forum Date
    Creation Sequence Interfaith Dialogues Jun 17, 2006
    Consequences of missing Sikh girls Sikh Sikhi Sikhism Feb 26, 2006
    Action & Consequence Spiritual Articles Oct 3, 2005

  3. kerry_ja@yahoo.com

    kerry_ja@yahoo.com
    Expand Collapse
    Guest

    Multiply by 2, subtract 1

    Everett wrote:
    > I would like to duplicate a formula used in Excel to update a table in
    > Access. The Excel formula is from the edit, fill, series and then the step
    > values menu. Basically I want to assign a value to the records that counts by
    > 2 or 3s or what ever value I need.
    > So the sequence would be 1,3,5,7,9 and so on. I have a table that has a
    > sequence number already but it runs 1,2,3,4,5,6,7 and so on. I would like to
    > find a formula that would work off of these values that I already have. Or in
    > other words change 1to1 2to3 3to5 4to7 and so on. What's that formula? Any
    > ideas.
    >
    > Thanks
    >
    > Everett
     
  4. Everett

    Everett
    Expand Collapse
    Guest

    Nice....I feel a little bit stupid right now. can you help with this one? 2+2

    Thanks

    "kerry_ja@yahoo.com" wrote:

    > Multiply by 2, subtract 1
    >
    > Everett wrote:
    > > I would like to duplicate a formula used in Excel to update a table in
    > > Access. The Excel formula is from the edit, fill, series and then the step
    > > values menu. Basically I want to assign a value to the records that counts by
    > > 2 or 3s or what ever value I need.
    > > So the sequence would be 1,3,5,7,9 and so on. I have a table that has a
    > > sequence number already but it runs 1,2,3,4,5,6,7 and so on. I would like to
    > > find a formula that would work off of these values that I already have. Or in
    > > other words change 1to1 2to3 3to5 4to7 and so on. What's that formula? Any
    > > ideas.
    > >
    > > Thanks
    > >
    > > Everett

    >
    >
     
  5. Everett

    Everett
    Expand Collapse
    Guest

    Thanks again, That is half of the problem. The other half is now assigning
    even number to a group of records starting at 2.

    "kerry_ja@yahoo.com" wrote:

    > Multiply by 2, subtract 1
    >
    > Everett wrote:
    > > I would like to duplicate a formula used in Excel to update a table in
    > > Access. The Excel formula is from the edit, fill, series and then the step
    > > values menu. Basically I want to assign a value to the records that counts by
    > > 2 or 3s or what ever value I need.
    > > So the sequence would be 1,3,5,7,9 and so on. I have a table that has a
    > > sequence number already but it runs 1,2,3,4,5,6,7 and so on. I would like to
    > > find a formula that would work off of these values that I already have. Or in
    > > other words change 1to1 2to3 3to5 4to7 and so on. What's that formula? Any
    > > ideas.
    > >
    > > Thanks
    > >
    > > Everett

    >
    >
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 12 Jun 2006 21:55:01 -0700, Everett
    <Everett@discussions.microsoft.com> wrote:

    Umm...

    Multiply by 2, DON'T subtract 1.

    >Thanks again, That is half of the problem. The other half is now assigning
    >even number to a group of records starting at 2.
    >
    >"kerry_ja@yahoo.com" wrote:
    >
    >> Multiply by 2, subtract 1


    John W. Vinson[MVP]
     
  7. Everett

    Everett
    Expand Collapse
    Guest

    On the second set of numbers I have no number to multiply. That’s the number
    I need to assign.

    Here is the whole problem.
    I am creating a list that will be used to produce a mailing so order is
    essential.
    I start with a group of records that have been presorted for mailing. Lets
    say for this example I have 30 records. (Actually there is 30,000).
    I am going to print them 2up on an Icon 1050 using Planet Press (in case you
    are familiar with them)
    In order to keep them in zip code order when printing 2 up I need to reorder
    the records.
    Look at it this way… the are to records on the sheet, position 1 on the top
    and position 2 on the bottom. Position 1 needs records 1-15 and position 2
    needs records 16-30.
    When it prints planet press will print the records in order. 1,2,3,4,5,6,7,8
    with out rearranging the order it will print record 1 in the first position
    then record 2 in the second position. I need record 16 in the second
    position. So the first part of this problem was reordering the first set of
    records that have a usable record ID but the second set is where I’m stuck
    now. Any Ideas?


    "John Vinson" wrote:

    > On Mon, 12 Jun 2006 21:55:01 -0700, Everett
    > <Everett@discussions.microsoft.com> wrote:
    >
    > Umm...
    >
    > Multiply by 2, DON'T subtract 1.
    >
    > >Thanks again, That is half of the problem. The other half is now assigning
    > >even number to a group of records starting at 2.
    > >
    > >"kerry_ja@yahoo.com" wrote:
    > >
    > >> Multiply by 2, subtract 1

    >
    > John W. Vinson[MVP]
    >
     

Share This Page