Apologies for how simple this probably is but I can't find anything on the web that helps...
I have a table named Clients. This consists of two fields - Client (text) and Benchmark (Value)
I have another table where various fields are selected from drop down, one of the being a Client and another being a value that is entered named Qty.
I then want another field that takes the Benchmark for the selected Client and multiplies by the Qty value.
I can see how to add a calculated field but I can't seem to be able to select the Benchmark field to multiply by the Qty entered.
I am using Access 2013.
Thanks
I have a table named Clients. This consists of two fields - Client (text) and Benchmark (Value)
I have another table where various fields are selected from drop down, one of the being a Client and another being a value that is entered named Qty.
I then want another field that takes the Benchmark for the selected Client and multiplies by the Qty value.
I can see how to add a calculated field but I can't seem to be able to select the Benchmark field to multiply by the Qty entered.
I am using Access 2013.
Thanks