one entry into two fields, please

[Deron O'Bryant]

I am very new to Access.
I want to have a field that when an entry is added to it, it will
automatically put the same entry into another field in the same table. The
first field is named UserName and I want the data in the UserName field to
go to a field called UserID. I want to be able to produce two
table(queries?) from the this table that have the same data. The first query
has the field UserName, password, etc, the second query has UserID,
password, etc. The UserName and UserID data should come from one entry in
the first table's UserName field. I need these two tables(queries?) for
other programs that need the exact field names (UserName & UserID) to
authenticate the users. These will have the same data, just different field
names. the authentication programs are very strict on the names of the
fields that can be used for the authentication process.

Any help would be greatly appreciated, or even a point in the right
direction as to what I am lookoing for (i.e. what to lookup in help or
books?)

Thank you
Deron

[John Turner]

Deron,

You do not want to duplicate the data in the table.

You can modify the resulting field name in a query.
Let's say that the table contains UserName and you now want
to produce an extract for UserID.

Start a new Query and show the Table
In the Field Name, enter:

UserID: UserName

Make sure you enter the colon after UserID.

Run the query and you will see that the field name is 'UserID'.
You can use the query as input to a form, report, etc. (the same as a table).

John

[John Turner]