Hide rows that have values zero 1

[KimVong]

I'm trying to create a report that will hid the rows that have values of zeros.

for instance, this is what I have now

des price
A 1
B 2
C 0


How can I make the report to just show

des price
A 1
B 2

Any help is appreciate.
Kim

 

[CosmoKramer]

In the On Format event of your report's detail section put code like this:

If Me.price = 0 Then
   Cancel = True
End If

This will cancel the detail line if price = 0.

 

[KimVong]

CosmoKramer
what is Me.price? I know what price is but what is "Me"?
thanks

 

[CosmoKramer]

The Me property is basically a reference to the current form or report. It's a way of using a shortcut instead of the full reference.....

 

[cmgaviao]

If you based the report on a query, just add that criteria to the query and don't return rows where price =0