I have a table form that is based on query. The form is populated with 2 columns of data and the 3rd column is [quantity] and is for the user tu put the quantity in. Not all the rows will have a quantity and some of them will remain blank. I would like to generate a report on the form (or query) that would only display the rows where [quantity] is not blank. I have tried a few things with no results. Thanks in advance.

A little more research and got it with this:

Code:
Private Sub Report_Load()
Me.Filter = "Quantity <> null"
Me.FilterOn = True

End Sub