Count qery but needs to display 0

[Simon]

I am trying to get a query to work that will count how many people have
requested a brochure. If no brochure have been requested how in teh
query do u set the count to be 0

Thanks

 

[Ron2006]

me.fieldnameonform = dCount ("[fieldnameinquery]", "Query That Selects
Desired Records")

If the underlying table has an ID field then [fieldnameinquery] should
probably be [ID]

Ron

 

[Douglas J. Steele]

Your suggestion of ID is a good one, but DCount("*", ...) is usually best.

When you list a field, rather than *, DCount ignores any of the fields that
are Null.

 

[Ron2006]

Doublas, thank you for the insight. I knew (experience) that it
ignored null entries, The * sounds like a good solution.

Do you know if using * instead of a single always present field like
"ID" will go any slower in an MDB on a network, particularly on records
with many fields?

Ron