Access calculating field

[Jevante351]

Hello, I am creating a database but have a little issue. I want to create a calculating field by pulling data from one table and add it to the current one. I am unsure of how to carry out this.

[Bob Fitz]

Are you talking about actually adding two numbers and saving the result to a table or are you trying to add two strings together.

[CJ_London]

some context would help - for example does one table hold current stock and the other table transactions and you want to update the current stock for each transaction?

[Jevante351]

Hello Bob, I have two tables in the access data base. One is called Master formulary which shows the on-hand total of inventory items, and the other table has Sales order being received. I want to add a calculating field in the mater formulary table that adds the on-hand plus the order received from the sales order table. I hope this provided more insight.

[Jevante351]

Hello Ajax, I have two tables in the access data base. One is called Master formulary which shows the on-hand total of inventory items, and the other table has Sales order being received. I want to add a calculating field in the mater formulary table that adds the on-hand plus the order received from the sales order table. I hope this provided more insight.

[Welshgasman]

You do know you can edit your posts and not have to duplicate them for a single name?

[Bob Fitz]

Hello Bob, I have two tables in the access data base. One is called Master formulary which shows the on-hand total of inventory items, and the other table has Sales order being received. I want to add a calculating field in the mater formulary table that adds the on-hand plus the order received from the sales order table. I hope this provided more insight.

You may find the following link of interest: http://allenbrowne.com/AppInventory.html