Hide data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
Click to expand...
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.
 
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
 
Perfect! Thanks very much!

Ken

babyatx13 via AccessMonster.com said:
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
Click to expand...
 
Back
Top