calculations on text data type

[Richey]

I have a form which is based on a table, where the data types are text - in most cases the entries in the text fields will be numbers.
I want the continious form to do a sum, in the form footer, on the text boxes. Obviously with them being data type text, it won't work.
Is there a way round this?
Thanks

Richey

 

[Steve101]

Richie,
Try this:

(a) Add an unbound text control in the form footer of your form.

(b) Set its ControlSource property to the following:
=Sum(IIf(IsNumeric([SourceControl]),Val([SourceControl]),0))

In the above setting, change SourceControl to the name of your control which you want to summed.

This should hopefully do the trick for you,

Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[Richey]

brilliant! thanks