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.
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.
Are you talking about actually adding two numbers and saving the result to a table or are you trying to add two strings together.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
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?
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.
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.
You do know you can edit your posts and not have to duplicate them for a single name?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
You may find the following link of interest: http://allenbrowne.com/AppInventory.htmlHello 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.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick