If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to do a SUM and getting Too Complicated
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? |
#2
|
|||
|
|||
Trying to do a SUM and getting Too Complicated
I have discovered that some of the fields are coming up error so that is why
it won't work. Looking into it. swaggers wrote: 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? |
Thread Tools | |
Display Modes | |
|
|