Totals

[Guest]

Ok, I hope I can explain this. I have a table which holds PO information.
I then created a form from a query of the table.

So for example this PO has 3 line items, in the table I would show quantity
ordered, and Unit price. In the query I created a new field call "LineTotal"
which multiplies qty*Unit Price. This gives me the total for each line.
Which I then display on the form.

What I need to know is how can I then get the total of the "LineTotal"
displayed on the form? In this case the only thing I can think of is
LineTotal+LineTotal+LineTotal which won't work.

I hope this made sense, and thank you for any help.

 

[Duane Hookom]

If I understand correctly, you can sum a field/column in your Form header or
footer section with an Control Source expression like:
=Sum([LineTotal])
or
=Sum([qty]*[Unit Price])