creating new fields

[Guest]

I would appreciate instructions on how to accomplish the following:

I would like to add two fields to a table that I have copied from another table (created a long time ago by someone else where I work). The first field will contain the result of dividing the value in one existing field by the values in another existing field. The second field to be added needs to contain a random number between 0 and 1.

I would like to add these fields without running a Make Table query to construct a new table with the added fields. How can I add these two fields to my copy of the table?

Thanks for your help. I can't find the info in my Access 97 for Dummies book.

 

[Rick Brandt]

I would appreciate instructions on how to accomplish the following:

I would like to add two fields to a table that I have copied from another

table (created a long time ago by someone else where I work). The first field
will contain the result of dividing the value in one existing field by the
values in another existing field. The second field to be added needs to contain
a random number between 0 and 1.

I would like to add these fields without running a Make Table query to

construct a new table with the added fields. How can I add these two fields to
my copy of the table?

Thanks for your help. I can't find the info in my Access 97 for Dummies book.

Your thinking "spreadsheet". Database tables do not hold values that are
derived from other values. This should be done in a query and then you just use
that instead of the table.