Cannot calculate listed field 1

[Stevehewitt]

Hello!

I have a report that gives a list of all deliveries within in certian time period. Included in this list is the price. EG.

Customer Price

WMMT £200
ROTHER £80
POXO £310

Etc.

The problem is that at the bottom of the report I need it to list the total price. I have tried using the
=Sum([Price])
parameter but it simply isn't working. Just giving a #ERROR message everytime.

Any ideas?

Thanks,

Steve Hewitt

 

[CosmoKramer]

Steve,

Where did you place this control?? Your syntax will work in the report footer, but not the page footer....



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams

 

[Stevehewitt]

Of course!

Fantastic. Thank you. Have a star for making me realise the bloody obvious! Sorry!

Thanks again,



Steve Hewitt