Cubic Calculation

[Seb]

Hello All

I was wondering how to work around this:

I have some fields in a subform. The fields are pulled from a TBL called tblQuoteItems. The fields in question are: Length, Width, Height, Qty
I then have a formula which is calculated in the query which works out the cubic weight as such:

[Qty]*((([Length]/100)*([Width]/100)*([Height]/100))*333) AS CubicWeight

I need to sum txtCubicweight, which shows the cubicweight value....but all it gives me is an error.
I've read somewhere (probably on here) that access cannot sum a calculated field....Not sure if thats right, but sureley there's a workaround?
Anyways, thanks in advance guys

Seb

 

[RoyVidar]

Did you try summing the field, not the control? By the query, you seem to have a field in the forms recordsource called CubicWeight, and a control on the form called txtCubicWeight. You will need to sum the field, not the control.

=Sum([CubicWeight])

 

[Seb]

Roy. you're a star. So simple, but I couldnt see it!

 

[missinglinq]

The fields in question are: Length, Width, Height...

If these are, in fact, the actual field names, you might want to consider changing Width and Height, as they are both, I believe, Reserved Words. Sooner or later they'll bring you trouble.

 

[RoyVidar]

Funny thing, none of them are listed in neither http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 nor http://support.microsoft.com/kb/321266/EN-US/, but at least Width gives a problem in form coding if it isn't referenced using late bound style (bang or parenthesis/quote).

The "summing" rule is that it can't sum controls, but fields in the recordsource