Functions on Forms

[whitestone]

Hi,

This is my first question on the forum.

I am creating a form and want to have a field that is a sum of two other firlds in the same form and table. I basically want to divide an amount recieved field by a total value field....

How do I do this?

Any help would be appreciated.

Ben Whitestone

 

[casey]

1.) Set the form's Record Source property to your table
2.) Display the forms field list and drop the fields to your form
3.) You can then add another textbox to the form
4.) Set the new textboxes' ContolSource property: =([Amount Recieved]/[Total Value])

I guessed at the name of your table fields. Change them to what you've actually named them.

Hope that helps.