Hi I am a newbie and having difficulties with the DCount function.
I have two forms with corresponding tables: Pol_Proc_Info (Policies) and Req_Rev_PP (Requests). In the Policies form I want to count how many records exist in the Requests Table which correspond to the SecCode of the current record in the Policies Form.
If I try this it does not correctly count #in Req_Rev_PP that has same SecCode as current record in Pol_Proc_Info (returns 0):
I can get the correct count when I give the exact value of SecCode
(e.g. =DCount("[SecCode]","[Req_Rev_PP]","[SecCode] ='CP'") but not when I try to reference the current record.
Ultimately I want to count records in Req_Rev_PP that have the same NumCode AND the same SecCode as current record in Pol_Proc_Info (i.e., matching on two fields), but have not been able to match on one yet.