summary question

[vibemaster]

this is probably a dumb question but here it goes. i would like to be able to print

the total quantity of items on the bottom of my invoice. i have a field call "qty" that can be 1-999 items. all i want to do is keep a summary of the total qty and display it on my invoice.

thanks.

[MoonShadow]

i have a field call "qty" that can be 1-999 items

Hmmm, it doesn't sound like you are using a LineItems table since your Qty is within your Invoice table!? If you have multiple fields holding each item quantity (within your Invoice table), it would be:

Qty1 + Qty2 + Qty3 ... etc.

If you are using a LineItems table, create a calculation (number) in Invoices with:

Sum(LineItems::Qty)

Structurally, LineItems is the best way to go.

[vibemaster]

some more info. the DB i'm working with is business tracker. the qty field is in the "items" db. i want to print the total on the invoice. thanks for the help