Summing a calculated column

[Dsperry101 via AccessMonster.com]

Hello,
I am constructing a hydraulic fitting database to keep track of fittings
used and calculate replacement costs with the following calculation:
(([tblFtgs!fldFullStk]-[tblFtgs!fldOnHand])*([fldCostPer])))

where fldFullStk is the quanity to maintain , fldOnHand is the quanity
of fittings on hand and fldCostPer is cost per fitting.
The trouble is when I try to sum the column to get the total cost of
replacing all fittings either in a query or a report I get the error :
Cannot have a Memo , Ole or Hyperlink fields in aggregate
argument. Tried Dsub in VBA as well and still get the error.

Any suggestions ?

Thanks in advance DSperry101

 

[Michel Walsh]

SUM can be used over a computed expression. The problem is probably not with
SUM, but, I assume, with another field, elsewhere.


Your are in the query designer and you changed your standard select query
into a total query? If so, one of the initially selected field was maybe a
Memo, Ole, Hyperlink... remove it.


Vanderghast, Access MVP