I am in the process of learning access and need a bit of help getting my head around a total addup
I have two tables
Table 1
Key column is the export license # (text)
allocated spares (currency)
remaing spares (currency)
Table 2
key linked to export license # (text)
spares price (currency)
I want the remaining spares column to be populated with the allocated spares - the spares price for that export license #. There are going to be multiple spares prices for each export license #.
Am I going about it the right way by creating a column for remaining spares? If not then what is a better way of doing it? And HOW do I do it?
The two online access courses have not helped me much so far
Thanks in advance |