View Single Post
  #1 (permalink)  
Old June 5th, 2006, 04:52 PM
ebburks ebburks is offline
Authorized User
Join Date: May 2006
Location: Elk Grove, CA, USA.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

For example,
Type Total Value
607 900
608 100
607 100

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.

Reply With Quote