Hi,
I have created a new DB to show current stock feeds. I have numerous tables, providing different data of stock within the company. In my form, I have the planned stock due in for each week and also the confirmed stock due in for each week. I have added another row beneath these fields, where I want to show the total of both fields together.
Do I add coding to the properties of the new fields added? Or would I create an update query (as I have been advised this) and link it to my new fields?
My tables are linked, I just cant figure out how to sum the 2 fields together and to get it to show in my form?
Thanks,