Odd and Even numbers

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I copied and pasted 2000 records from a web site to excell
then imported to an access table.

Because of the original structure of the data, the first
record in this one field table is Company Name and the
next record is the address of the company in the previous
record.

I added a autonumber field to the table so now all the odd
numbered records represent CompanyName and the even
numbered records represent CompanyAddress.

I intended to do a make table query selecting only the odd
numbered records and use an autonumber field to create a
table with only business names, then do a make table query
selecting the even number records in the same manner. I
should then be able to create a new field in the business
names table for the addresses and update that field from
the address table linking the autonumber fields of each
table.

The problem is that I don't know how to make the query
recognize even and odd numbers.

Any ideas or better ways to accomplish my overall task of
associating the bus name with it's address in the next
field?
 
Why not just open it in Excell, insert a new column between company name and
address, in that column for row 1, put something like = C2
for row 2, put = C3
etc.

Now you should have...

ABC Pest 123 Main
123 Main
Clip Cutters 555 Avenue M
555 Avenue M



Sort the entire mess by column A and then scroll to where the blank column
A's begin. This should be the area where the original address lives in
column C. Delete them.




Then import the cleaned up version to Access.


Rick B




I copied and pasted 2000 records from a web site to excell
then imported to an access table.

Because of the original structure of the data, the first
record in this one field table is Company Name and the
next record is the address of the company in the previous
record.

I added a autonumber field to the table so now all the odd
numbered records represent CompanyName and the even
numbered records represent CompanyAddress.

I intended to do a make table query selecting only the odd
numbered records and use an autonumber field to create a
table with only business names, then do a make table query
selecting the even number records in the same manner. I
should then be able to create a new field in the business
names table for the addresses and update that field from
the address table linking the autonumber fields of each
table.

The problem is that I don't know how to make the query
recognize even and odd numbers.

Any ideas or better ways to accomplish my overall task of
associating the bus name with it's address in the next
field?
 
LOL

No problem. I'm assuming from your response that you got it all squared
away.

Have a good weekend.

Rick B

Of course, sometimes the trees get in the way of the
forest.

Thanks

Bill
 
Back
Top