Removing a field

[Jacob Frankham]

Hi

I have a report which has mainly numbers (Sums, Counts etc) on it

What I need to be able to do is (call the field [myField])

If [myField] = 0 then ignore the whole record


Now, the logical explanation would be to ensure that it wasn't in the query,
HOWEVER I need it in the query because I am using COUNT to create a total on
the number of records.

So, is there any way of 'not showing' any records where a certain field of
the record = 0 ?

Thanks in advance !

J

 

[JoeElla]

On the "ON Print" event of the report detail section add this code
if [myField]=0 then
let field1.visible=false (do this for each field of the record)
else
let field1.visible=true (same for all fields of record)
endif

There may be other ways, but this will work.

 

[Jacob Frankham]

Thanks guys !!!!!

On the "ON Print" event of the report detail section add this code
if [myField]=0 then
let field1.visible=false (do this for each field of the record)
else
let field1.visible=true (same for all fields of record)
endif

There may be other ways, but this will work.

Hi

I have a report which has mainly numbers (Sums, Counts etc) on it

What I need to be able to do is (call the field [myField])

If [myField] = 0 then ignore the whole record


Now, the logical explanation would be to ensure that it wasn't in the query,
HOWEVER I need it in the query because I am using COUNT to create a total on
the number of records.

So, is there any way of 'not showing' any records where a certain field of
the record = 0 ?

Thanks in advance !

J