Totalling a group of forms with subforms

[jvcdude]

Hi all

I have a small stock control DB (Access 2002/3) which I have been running and improving gradually.
I can't seem to get the syntax or other settings right to total up a set of forms (invoices) and would appreciate a quick pointer in the right direction. I have never got to grips with code and use simple calculated fields and macro scripts...so keep it simple please!

eg my sales invoice contains a subform with lots of picked stock items using [retail] as the price for each. On the bottom of the subform I have a control [Total] set as =sum[retail] and I can then calculate an invoice total on the main invoice with [frminvoicedetail].[form]![total]....then also adding/subtracting other fields like [accessories] or [discount] to get a grand total...which is a calculated, not a stored field.
If I try to put it in the detail or footer of the form with a control =sum([Total] or similar all I can get is #error.
I can make the totalling work on another form in continuous form view, but with a subform this view is unavailable


help please?

JVCdude

 

[bubba100]

Open Access go to File>New then look at the templates on your machine (on mine it is a tab called Databases). Find one that says Ledger. This might give you several ideas.