Trying to do a SUM and getting Too Complicated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

swaggers - 30 Oct 2009 16:54 GMT

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?

Reply to this Message

swaggers - 30 Oct 2009 17:14 GMT

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

>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
[quoted text clipped - 7 lines]
>If I try to SUM that it comes up with an error that it is too complicated.
>Any ideas?

Reply to this Message