Information from one table to another table?

[JMill248]

Does anyone know how information into one table is sent to another
table. For example in excel if you are in one sheet and you want that
same information in another sheet all you have to do is use the "="
sign and select the cell. How do you do this same operation in Access?

 

[BruceM]

Access is completely different from Excel. There are no fixed location
references in tables. To reference information in another table you need to
identify the information. Rather than telling Access to get the information
in Table2, Row 5 you need to tell Access to find the record in Table2 in
which data meet certain criteria (the most recent date, a particular
customer, the largest value, etc.)

What exactly are you trying to do?

 

[JMill248]

Access is completely different from Excel.  There are no fixed location
references in tables.  To reference information in another table you need to
identify the information.  Rather than telling Access to get the information
in Table2, Row 5 you need to tell Access to find the record in Table2 in
which data meet certain criteria (the most recent date, a particular
customer, the largest value, etc.)

What exactly are you trying to do?






- Show quoted text -

What I am trying to do is copy the exact same information from a
record and put the exact information into another table. Example in
Table Scrap I enter "2" into the first fireld record one. I want "2"
entered into Field Scrap Record one Table PPM. I would like to make
that a continuous function.

 

[Lance]

What is the purpose of Table PPM? Is this some kind of archive? Would the
"Scrap Record" field in both tables always be equal?

 

[JMill248]

What is the purpose of Table PPM?  Is this some kind of archive?  Would the
"Scrap Record" field in both tables always be equal?






- Show quoted text -

The purpose of Table PPM is to store calculate the PPM of
machinery,shops, and the department overall.
Both records should be the same in each table.

I tried making a query but it did not work.

 

[Lance]

In that case there is no need to store that value in both tables. As long as
you have it in 1 table you have all the access to that value you'll ever need.

Also, it's usually not a good idea to store calculated values. Store what
you need to work with, then do the calculations when you need to see them.

 

[Sylvain Lafontaine]

The purpose of Table PPM is to store calculate the PPM of
machinery,shops, and the department overall.
Both records should be the same in each table.

I tried making a query but it did not work.

If you have a problem making the query that you need, a better solution
would be to find out how to do it instead of copying all the data from one
table to another.

You should start a new thread posting the (partial) schema of your tables, a
sample of the data, the desired result and the query(ies) that you have
tried to make to work so far.