I have a report that shows me the difference in planned against actual manning. It draws its data from a query. The fields in both report and query are (except for fields beginning "Additional Men..." which are not in the query):
C/Q Number; 1st Fix Men Plan; 1st Fix Men ACT; Additional Men Rqd 1st Fix; 2nd Fix Men Plan; 2nd Fix Men ACT; Additional Men Rqd 2nd Fix; 3rd Fix Men Plan; 3rd Fix Men ACT; Additional Men Rqd 3rd Fix; Snag 1 Men ACT; Snag 2Men ACT; Additional Men Rqd Snags; Completion Date
All "Additional Men Rqd..." fields have a calculation in to produce the difference between the Actual and Plan fields (e.g. =[2nd Fix Men ACT]-[2nd Fix Men Plan]).
What I would like the report to do is filter out any records that show "0" as the result of the calculations. However "0" needs to be in all of the "Additional Men Rqd..." calculation fields. If there is any other numeral - either positive or negative, the line should stay in the report.
Can anyone help me sort this one out? Thanks!
C/Q Number; 1st Fix Men Plan; 1st Fix Men ACT; Additional Men Rqd 1st Fix; 2nd Fix Men Plan; 2nd Fix Men ACT; Additional Men Rqd 2nd Fix; 3rd Fix Men Plan; 3rd Fix Men ACT; Additional Men Rqd 3rd Fix; Snag 1 Men ACT; Snag 2Men ACT; Additional Men Rqd Snags; Completion Date
All "Additional Men Rqd..." fields have a calculation in to produce the difference between the Actual and Plan fields (e.g. =[2nd Fix Men ACT]-[2nd Fix Men Plan]).
What I would like the report to do is filter out any records that show "0" as the result of the calculations. However "0" needs to be in all of the "Additional Men Rqd..." calculation fields. If there is any other numeral - either positive or negative, the line should stay in the report.
Can anyone help me sort this one out? Thanks!
