Trying to do a SUM and getting Too Complicated

S

swaggers

I have a report I am writing to get a price out of a large memo field. I've
created a search that will find it for the report but I can not get it to
total on group footer.

=Mid([fdescmemo],InStr((InStr([fdescmemo],Trim([fbompart]))),[fdescmemo],
"Amount: ")+8,InStr((InStr([fdescmemo],Trim([fbompart]))),[fdescmemo],", Wei")
-(InStr((InStr([fdescmemo],Trim([fbompart]))),[fdescmemo],"Amount: ")+8))*(1-
([fdisrate]*0.01))

If I try to SUM that it comes up with an error that it is too complicated.
Any ideas?
 
S

swaggers

I have discovered that some of the fields are coming up error so that is why
it won't work. Looking into it.
 
Top