Sum

[John]

Hi
I have a query which has only fou fiels per entry.
COST COSTVAT LABOUR LABOURVAT

These fileds are all calculated fields in a query
if the Cost is £10.00 the CostVAT is £1.75
If the Labour is £10.00 the LabourVAT is £1.75

I would like other fields at the end of the above fields which will sum all
the SUMCOST SUMCOSTVAT etc

I cannot work out how to do a calculated sum field.

Any Help Please

Regards

John

 

[John]

Sorry that was a bit ambiguous,
The fields I need to show are running sum fields. " I Think?"
These fields will total up all COST, VAT etc from all records

Regards

John

 

[Guest]

You can have running sums in a form or report.

 

[John]

KARL
How do I set a running sum field on a form please?

Regards

John

 

[Guest]

I may have mispoke about a form but try an unbound textbox and use DSum
function.

 

[John W. Vinson]

You can't, not with only the information you've shown! You need some field
which is in strictly ascending (or descending) order within the subform.

You can do a running sum on a Report - but that's not available on a Form.

KARL
How do I set a running sum field on a form please?

Regards

John

John W. Vinson [MVP]

 

[John]

Thanks Guys
I actually used a query based on the fields and an expression within the
query to get my results.
Crude but it works!!

Kind Regards

John