Hi Richard

This is my first time in contacting you for help with my Access Database.

I have an issue getting a calculation to work the way I need it to work and I'm not sure where I should be making this calculation i.e. in a query or in a textbox within a subform where some of the figures reside.

There are 3 tables in question where I have a query.

tbl2CustomerEnquiry, tbl3CustomerEstimate & tblMaterials.

The query (called qryCustEstMaterials has the following fields in this order - EstID from tbl3CustomerEstimate, SupplierID from tblMaterials, MaterialsID from tblMaterials, Invoiced (tickboc on a subform) from tbl3CustomerEstimate, Quantity from tbl3 CustomerEstimate, ListPrice from tblMaterials, ActualPrice from tbl3CustomerEstimate (this figure can change often), MatMkUp from tbl3CustomerEstimate (percentage for the markup).

I'm trying to make an extression or VBA in either the query or the subform textbox to "sum if" the ActualPrice has a cost in it by the Quantity (ActualPrice has a deafult set to '0') otherwise sum the ListPrice by the Quantity either/or with a name called 'SubCost'

I have tried the following sintax without success...

Sum(IIF([ActualPrice]=0, Sum([ListPrice]*[Quantity], [ActualPrice]*[Quantity])),0)

What am I doing wrong!?

Kind Regards

Brian Adams