Prev: Default Printer in Access 2007
Next: Non alphabetic sorting
From: Lonewolf on 27 Apr 2010 19:09
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!!!
From: Armen Stein on 27 Apr 2010 19:37
On Tue, 27 Apr 2010 16:09:01 -0700, Lonewolf
<Lonewolf(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Default Printer in Access 2007
Next: Non alphabetic sorting