Qty On Hand

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please,
I have an Inventory DataBase that where I have a 10lb Fire
Extinguisher Table and a Form designed from that. So far
so good. I have "Serial No.", "Manufacturer", "Date In
Service", "Date Out of Service" and then a check box
for "Sold yes/no". What I'm trying to get is a "Qty On
Hand" minus what is checked as Sold. I can't seem to get
this to work. Perhaps any ideas out there?
 
Put the following in the control source of a textbox on your form:

=DCount("*","NameOfTable","[Sold] = False")
 
Back
Top