Qty On Hand

[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?

 

[PC Datasheet]

Put the following in the control source of a textbox on your form:

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