Hide data

[Guest]

I've created a report that list items in an inventory. The report uses a
query as its data source. The quantity-on-hand (QOH) is determined via an
expression in the query of "Received" less "Issued".

Is there any way, either in the query or report, that I can hide any items
where QOH equals 0? I tried setting the criteria in the query's QOH field to

0< but it doesn't work. I also tried setting the criteria to "NOT = 0" but

it didn't work as well.

Seems to me that there's a way, via VBA in the report, to hide these
transactions, but I can't recall it. Thanks.

 

[babyatx13 via AccessMonster.com]

Ken,

In VBA Code should look something like this.

If QOH.value = 0 then
QOH.visible = False
QOHLabel.visible = False
Else
QOH.visible = True
QOHLabel.visible = True
End If

hope this helps
K Board

 

[Guest]

Perfect! Thanks very much!

Ken

Ken,

In VBA Code should look something like this.

If QOH.value = 0 then
QOH.visible = False
QOHLabel.visible = False
Else
QOH.visible = True
QOHLabel.visible = True
End If

hope this helps
K Board

 

[babyatx13 via AccessMonster.com]

you are very welcome )
K Board

Perfect! Thanks very much!

Ken

Ken,

[quoted text clipped - 22 lines]