Why does this not work? **Resolved**
On the footer of a from set to "Continuous Forms" I have a text box with this code in it.
=IIf(IsNull(Sum([FinalPrice])),0,Sum([FinalPrice]))
FinalPrice is the name of a text box that contains another calculation. Why should this not work this time?
Last time I did this the form was backed by a table and was filtered. this time it's backed by a query. surely that's not the reason!?
the output is: #Error
IT's an access 2000 database
The control source is now set to =sum([finalprice]) and still nothing.
It errors whatever I do.
For a time a second textbox set as defult = sum([finalprice]) gave the first row as an answer but that sits there blank.
I can find no deviation from when I've done it before.
FinalPrice is achieved via =([Unit Price]*[AmmountReq]) as the control
and the whole is backed by a query that has SQL:
Code:
SELECT Job.[Job ID], Example.Discriptor, Example.Size, Feature.Name, Feature.Measure, Material_Required.Qantity, _
[GET Cheapest Supplier].Qty, [GET Cheapest Supplier].Unit.Name, [GET Cheapest Supplier].[Unit Price], [GET Cheapest Supplier].[Unit ID], _
[GET Cheapest Supplier].Supplier.Name
FROM (Feature LEFT JOIN ([GET Cheapest Supplier] RIGHT JOIN Material_Required ON [GET Cheapest Supplier].[Unit ID] = _
Material_Required.[Unit ID]) ON Feature.[Feature ID] = Material_Required.[Feature ID]) RIGHT JOIN (Job LEFT JOIN Example ON Job.[Job ID] = Example.[Job ID]) _
ON Feature.[Feature ID] = Example.[Feature ID]
WHERE (((Example.Disable)<>True))
WITH OWNERACCESS OPTION;
could my query be in the way somehow? I thought you could pritty much treat them like tables.