DCount (1 Viewer)

[GreenshootProgrammer]

In my database when an item is currently being loaned the item's loaned field will have a 1 to indicate this. When the item is returned the value is 0. Only so many items are available and when I use the DCount function it is counting the 0s as 1s. How do I solve this issue?

 

[plog]

Use the Dsum function.

http://www.techonthenet.com/access/functions/domain/dsum.php