if Qty Value is zero or less than

[mabino79]

is there a way to do

if Qty Value is zero or less than, the row from the report should be deleted or hide.

 

[June7]

Apply filter opening report.

DoCmd.OpenReport "reportname", , , "Qty>0"

 

[mabino79]

Apply filter opening report.

DoCmd.OpenReport "reportname", , , "Qty>0"

where to write the code, in Report opening button or in a module

 

[June7]

I would think button click event.

 

[arnelgp]

you can also put it in your report's Recordsource:

select * from yourTable where Nz(qty, 0) > 0

 

[June7]

If you want to make the filter dynamic based on user choices, review http://allenbrowne.com/ser-62.html

 

[oleronesoftwares]

where to write the code, in Report opening button or in a module

this can be put in a macro

 

[oleronesoftwares]

@Pat Hartman a macro with openreport action will do same , expecially if the user is not too farmiliar with VBA

 

[The_Doc_Man]

Now Pat, you KNOW that macros are the gateway drug of choice on the road to a full-blown VBA habit.

 

[The_Doc_Man]

Just to be serious for a moment, Pat, don't forget that for novices, Macros make more sense because they emulate ribbon-based actions. The fact that Access has a way to convert a lengthy Macro into VBA code just means that the Macro can be your quick-n-dirty method to get started and then come back later to clean it up. Which I must admit to having done more than once as a way to get something up fast and then fix it (via conversion) for version 2.