Removing a field

  • Thread starter Thread starter Jacob Frankham
  • Start date Start date
J

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
 
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.
 
Thanks guys !!!!!



JoeElla said:
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 wrote in message said:
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
Click to expand...
Click to expand...
 
Back
Top