Dcount with Multiple Criteria

[Ramone]

I'm stll having problems gettig my code to worke with
when using dcount with multiple criteria. Does it matter
if one of the criteria fields i'm refrencing in the table
is a drop down?

 

[tina]

probably. Lookup fields in tables typically show one value while actually
saving another value. suggest you remove the Lookups from your table. see
http://www.mvps.org/access/lookupfields.htm
for additional information.

hth