sequence 1,3,5,7,9

[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

 

[kerry_ja]

Multiply by 2, subtract 1

 

[Guest]

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

Thanks

 

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

 

[John Vinson]

On Mon, 12 Jun 2006 21:55:01 -0700, Everett

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.

John W. Vinson[MVP]

 

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