SUM(field)

[Gingerbread Man]

Hi

I have an accounts database in which I want to add the sum total of figures in the amount (text field) to appear in sub total (number field) which VAT is added to appear in VAT (number field) and finally end up with a grand total in the final (number field). It all works fine in the amount field if there is just one amount. As soon as I type in 2 or 3 amounts the sum is either just the first amount or an obscure figure. If I change amount field to a number field I can only type one number which is no good for invoicing. Any ideas?

[Raybaudi]

Hi

that way of making an invoice is indeed very strange !

Each single amount must be into its own field of a related table "Invoice Line Items".

So, if you have multiple amounts, you'll have multiple records.