Odd and Even numbers

From: Bill (bburn_at_iquest.net)
Date: 05/07/04 

Date: Fri, 7 May 2004 12:04:58 -0700

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?

Relevant Pages

  • Re: Odd and Even numbers
    ... I copied and pasted 2000 records from a web site to excell ... I added a autonumber field to the table so now all the odd ... I intended to do a make table query selecting only the odd ...
    (microsoft.public.access.queries)
  • Re: Duh, I though I was smart
    ... >Rick B ... >I added a autonumber field to the table so now all the odd ... >I intended to do a make table query selecting only the odd ...
    (microsoft.public.access.queries)
  • Duh, I though I was smart
    ... >I copied and pasted 2000 records from a web site to excell ... >I added a autonumber field to the table so now all the odd ... >I intended to do a make table query selecting only the odd ...
    (microsoft.public.access.queries)
  • Re: Adding auto-numbered field screws up Table order
    ... yet know how to work with an Append Query. ... Access to get the correct order. ... plus your AutoNumber field. ... >> wrong data shows up since the sort order is wrong. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Autonum problem
    ... Make a backup copy of the database, then run compact and repair on ... query and that query has the autonumber field in the field list. ... Jet will let you assign numbers to an autonumber field by an append query, ... The append query does not have the autonumber field as an output field. ...
    (microsoft.public.access.tablesdbdesign)
Loading