Character Limit?

[rschultz]

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((

)<>"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))​

 

[Kage]

Why don't you create a select query to identify the incorrect records. You could then review the records and make the corrections. The query in SQL View would be something like this:

SELECT Table1.id, Table1.CENTER, Table1.Route, Table1.BIL_NAME
FROM Table1 WHERE (((Table1.CENTER)<>"ER" And (Table1.CENTER)<>"WR" And (Table1.CENTER)<>"SE" And (Table1.CENTER)<>"NR")) OR (((Table1.Route)<>"Crinc")) OR (((Table1.BIL_NAME)<>"Scott" And (Table1.BIL_NAME)<>"Science" And (Table1.BIL_NAME)<>"Mesa" And (Table1.BIL_NAME)<>"Diamond" And (Table1.BIL_NAME)<>"Fred" And (Table1.BIL_NAME)<>"Landfill"));

Hope this helps.

 

[rschultz]

I have a select query that finds the records in the "Other" category but they want to have a line on the report that shows if there are any.

 

[Pat Hartman]

Add a subreport based on the query that Kage suggested.

 

[rschultz]

okay, sounds like a good idea. I created a subReport called "Other Status:" I have a field called Weigh_Net and in the SubReport Footer I have a Text box called TEXT6 with =SUM([Weigh_Net]/2000)

then in the main Report I have a textbox with:
=Sum([Reports]![MJs Report]![Other Status:]![Text6])

but I keep getting 0 as a results. What am I doing wrong

 

[rschultz]

I remembered than Pat has said not to reference the Control but to sum the formula so I also tried:

=Sum([Reports]![MJs Report]![Other Status:]![Weigh_Net])

in a textbox in the Report Footer of the main report but I still get 0