How do I calculate a total amount on a form in Access.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a Purchase Order form and I would like to calculate the "Total
Dollar Amount" of my items. Unfortunately everything I have tried is not
working. Could someone please send me an alternative solution.

Thanks,
Adickson
 
Being a bit down on my ESP quotient, it is difficult to tell what it is that
you have or may have (or not) tried.

Care to post more details?
 
Sure. I looked up calculating totals on forms in the MS Access Help and did
all of the suggestions. They included doing a text box and then typing it in
a control source. I kept getting an error message and it would not allow me
to go any further. I also tried doing it as a query and that did not work.
Can you offer any more suggestions.
 
Hi,

You might want to try a text box on either your form's header or footer and
place the following code inside of it (change table and field names to match
your table and field names):

=Dsum("Item_Price", "Purchase_Order")

Item_Price would represent your field and Purchase_Order would represent
your table.

Hope it helps.
 
Back
Top