Form's Unbound field question
I have created a table with the following fields:
Type, Total Value
I have created a separated Blank form and inserted an unbound field.
Here is what I am trying to do:
In the form, I want the unbound field to reflect the Total Value based on the type field.
Type Total Value
I want the separate formâs unbound field to show the value of all the 607 types which would be 1000.
I have been playing around with the dsum function but it is not working in the unbound field.
I created a query that work but when I try and insert the query into the field control source I am getting errors.
I know that I am close but donât think I am getting it.