If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I not show a record in a report when the total is zero?
I have a very simple DB where I track items. I have an ID, Description,
Intake #, Sold #, Remaining # (this is from subtracting the sold from the intake), and a total inventory (this is calculated using Dsum on remaining inventory based on description matches). I have a report that I wish will show all records that have a remaining balance, and just exclude the ones that have a zero balance. I tried: Private Sub Report_Load() If Remaining.Value = 0 Then ID.Visible = False Description.Visible = False Intake.Visible = False Sold.Visible = False Remaining.Visible = False Total_Inventory.Visible = False End If End Sub But it does not work.. Please help!!! |
#2
|
|||
|
|||
how do I not show a record in a report when the total is zero?
On Tue, 27 Apr 2010 16:09:01 -0700, Lonewolf
wrote: I have a report that I wish will show all records that have a remaining balance, and just exclude the ones that have a zero balance. Remove the code you showed - you're on the wrong track there. Make your report based on a query. In that query, specify criteria that give you the records you want to include on your report. Armen Stein Microsoft Access MVP www.JStreetTech.com |
Thread Tools | |
Display Modes | |
|
|