I need to find out if the totals are correct on a report so I have a class called "Other". My hope is to find out if there are any typos. I have a textbox called “Other” with the code listed below hoping to find any records that do not fall into the normal categories we have, but I seem to be running into a character limit. Anyone have any suggestions how I can check for records that don't fall into the normal categories?
=Sum(IIf((
=Sum(IIf((
)<>"ER" And (
)<>"WR" And (
)<>"SE" And (
)<>"NR" And ([Route])<>"Crinc" And ([BIL_NAME]) Not Like "*SCOTT*" And ([BIL_NAME]) Not Like "*Science*" And ([BIL_NAME]) Not Like "*Mesa*" And ([BIL_NAME]) Not Like "Diamond*" And ([BIL_NAME]) Not Like "Fred*" And ([BIL_NAME]) Not Like "*Landfill*",[weigh_net]/2000,0))