Re: calculation from query

[EMAIL PROTECTED] (Bart) wrote in message news:<[EMAIL PROTECTED]>...
> I've a query where I keep some fields:
> 
> btw
> excl
> incl
> total
> 
> I use this query as subform, now here 's my problem
> 
> I've got a textfield 'total' where I want to calculate the total from
> the query for the loaded form.
> 
> I've used the expressionbuilder to perform this:
> 
> =Sum([subfrm FaktuurTest].Form!Inclusief)
> 
> When I see the form in 'formview' I get the following message:
> 
> #Error
> 
> Someone got any id?

Hello Bart.

I'm not quite sure where you have your field located with
the above expression. Sounds like it's on the main form and
not the subform.

Perhaps you should make sure it's in the subform's "Form Footer"
to get the sum of the required field data. Then, on the main form
set a reference to the text field on the sumform.

Example for Sub Form: Make a text box called txtSumData
Source: =Sum([subfrm FaktuurTest].Form!Inclusief)

Example for Main Form: =[subfrmName].[Form]![txtSumData]

Regards,

Ray