totaling of fields

[Malcolm Mabe]

i have a form that records a sales persons results based on a query for that
person. i need the first record of the form to show total sales. at the
moment i'm clicking thru every record that adds the totals up as i go along.
a little crude eh?

how is this done?

 

[Rob Oldfield]

Easiest way to get the value will be to use something like a dsum. I
wouldn't recommend adding it in as another record on the form as that's
potentially going to be confusing e.g. if the user sorts the data. You'd be
better off just adding an unbound textbox onto the form and set it's source
to be the dsum.

(If you're desperate to add it as another record, then you could do that
using a union query.)