|Subject:||Sum calculated fields based on combo box columns|
|Date:||Mon, 1 Dec 2014|
I have a main form (based on tblOrders) with 2 subforms (subform 1: based on tblOrderDetails and subform 2: based on tblExchangeRates)
I have a calculated field "Value" on a subform 1 (see below for definition), which uses data in columns of a combox.
How can I total all "Value" fields on the form (=sum() function does not see calculated fields)? What is the workaround?
Thank you for your help.
tblOrders (one side)
tblOrderDetails (many side)
tblExchangeRates (many side)
PK - primary key
FK - foreign key