DCOUNT Dropdown

[Jamo via AccessMonster.com]

Hi,

All I am trying to do is a simple DCOUNT on a combo box from my table.

How many times does the word "Session" appear in table "Timeline". The field
is called "Event".

I try DCOUNT("Event","Timeline","Event = 'Session'") but get #ERROR.

Please help,

Many thanks.

 

[BruceM via AccessMonster.com]

When I have trouble with an expression I try leaving out the optional
arguments if I can (in this case the Where condition) as a test.

If it works without the Where, the next thing I would wonder is if Event is a
lookup field in the table. If so, I believe the actual stored value is a
number rather than what you see.