Field Location

[Debbie]

Hi,
I am a new user of Microsoft Access. I need to find out how I can set the
location of a field in a table. Below is what I mean--
eg fieldname Name Location 1-10
fieldname Age location 11
fieldname Gender location 12.....

thanks for all your help!
Debbie

 

[John W. Vinson]

Hi,
I am a new user of Microsoft Access. I need to find out how I can set the
location of a field in a table. Below is what I mean--
eg fieldname Name Location 1-10
fieldname Age location 11
fieldname Gender location 12.....

Why?

That is not information which would be particularly useful in an Access
database application, and - in strict relational theory - it's not even well
defined. The order of fields in a Table is irrelevant! You can create a Query
selecting any field that you wish.

In addition, each field can have one and only one column position (if you're
referring to columns in a datasheet). Are you talking about printed positions
on a page, so that the name would be stored as "Smith, John" or "Robertson,"
or "Wu, Li " or "Katzenelle" (for Dr. Hans Katzenellenbogen who I knew many
years back)?

Please explain what you're trying to accomplish.

 

[Tom van Stiphout]

On Mon, 10 Mar 2008 13:19:01 -0700, Debbie

It appears you have a fixed-width text file with Name in the first 10
positions, Age in the 11th, etc.
You can import such data (the exact menu option depends on your
version which you did not mention) into a (new) Access table that will
have fields Location, Age, etc. An Access table does not use
"location"; this concept is only used when importing data.

-Tom.