Access 2003 - column for adding numbers

[opus]

In a form, I want to create and imbed a blank column to input a list of
numbers that when added will automatically total in a separate and designated
field in the same form, either as part of the same table or another table and
that list and total remain as a permanent record within a specific record ID.

 

[KARL DEWEY]

that list and total remain as a permanent record within a specific record ID.
What type of field do you expect to use to store the list of numbers and the
total?

 

[opus]

I plan to use simple numbers and currency figures in text and currency fields.

 

[KARL DEWEY]

You say that you will put a LIST of numbers entered into a text field?

Post your table structure please.

 

[opus]

No. I want to post the sum only to the field.
The column of numbers I would like can exist as a separate entity such as an
imbedded Excel sheet, but I must be able to retrieve the list it when I pull
up the other records under the same ID number.

You say that you will put a LIST of numbers entered into a text field?

Post your table structure please.

I plan to use simple numbers and currency figures in text and currency fields.

[quoted text clipped - 6 lines]

 

[Rick Brandt]

No. I want to post the sum only to the field.
The column of numbers I would like can exist as a separate entity
such as an imbedded Excel sheet, but I must be able to retrieve the
list it when I pull up the other records under the same ID number.

Retrieve it from where? If you need to save it then you need to put it in a
table and it is not appropriate to store multiple items in a single field.
You should have a second table related to the first (one to many) and store
each number as record in the new table.

 

[KARL DEWEY]

Sounds like you need to use a subform instead of 'imbedded Excel sheet.'
Use a table with a related subordinate table for the list of data entry
numbers.

No. I want to post the sum only to the field.
The column of numbers I would like can exist as a separate entity such as an
imbedded Excel sheet, but I must be able to retrieve the list it when I pull
up the other records under the same ID number.

You say that you will put a LIST of numbers entered into a text field?

Post your table structure please.

I plan to use simple numbers and currency figures in text and currency fields.

[quoted text clipped - 6 lines]

field in the same form, either as part of the same table or another table and
that list and total remain as a permanent record within a specific record ID.

 

[opus]

That sounds like what I'm looking for. How do I create a table with a
related subordinate table for a list of data entry numbers?

Sounds like you need to use a subform instead of 'imbedded Excel sheet.'
Use a table with a related subordinate table for the list of data entry
numbers.

No. I want to post the sum only to the field.
The column of numbers I would like can exist as a separate entity such as an

[quoted text clipped - 10 lines]

 

[KARL DEWEY]

Create your main table with the fields you want and add one more that is an
Autonumber field. Name it something like MainID.
Create your related table with the fields you want and add one more that is
an Number – Integer field. Name it MainID.
Click on menu TOOLS – Relationships. Click on the icon that has a yellow
plus sign and a table. Select your two tables. Click on the MainID of the
main table and drag to the related table MainID field.
Select Enforce Referential Integrity and Cascade Update Related Fields. Save.
Create a query using the two tables and left join the main to the related
table.
Create a main form and a subform (datasheet view) using the query as record
source for both. Insert the subform in the main form and set the Master/Child
link using the MainID.

That sounds like what I'm looking for. How do I create a table with a
related subordinate table for a list of data entry numbers?

Sounds like you need to use a subform instead of 'imbedded Excel sheet.'
Use a table with a related subordinate table for the list of data entry
numbers.

No. I want to post the sum only to the field.
The column of numbers I would like can exist as a separate entity such as an

[quoted text clipped - 10 lines]

field in the same form, either as part of the same table or another table and
that list and total remain as a permanent record within a specific record ID.