Count number of days

[ramindya]

Hello:

I have a table tblCallLog which has a field called "Calldate".

I need to calculate number of counts of days which meets the following condition:



Currentdate - Calldate <= 60

This is the Sql "qryPhone1calllog" I tried but it does not work..

SELECT tblCallLog.CCSSID, tblCallLog.CallPhone1 AS Phone, tblCallLog.Day, tblCallLog.calldate,tblCallLog.LM, tblCallLog.notes, IIf((Date()-[calldate])<=60,[calldate],Null) AS PhoneC, tblCallLog.AppointAmPm, tblCallLog.CallType
FROM tblCCSSExpansionTrackingMain AS M LEFT JOIN tblCallLog ON [M].CCSSID=tblCallLog.CCSSID
WHERE (((tblCallLog.CallPhone1)=Forms![frmCallTrack-Cases]!CONTPHONE1) And ((M.CCSSID)=Forms![frmCallTrack-Cases]!CCSSID))
ORDER BY tblCallLog.Seq_Num;

and in the controlsource propoerty I mentioned =DCount("[PhoneC]","qryPhone1CallLog","CCSSID=Forms![frmCallTrack-Cases]!CCSSID")

Can you let me know the issue ? Thanks !!

[June7]

Need to concatenate variables in the WHERE CONDITION argument, not place within quotes. Reference to form control/field is a variable:

=DCount("[PhoneC]","qryPhone1CallLog","CCSSID=" & Forms![frmCallTrack-Cases]!CCSSID)

Assumes CCSSID is a numeric value. If it is text, need apostrophe delimiters (dates need #).

=DCount("[PhoneC]","qryPhone1CallLog","CCSSID='" & Forms![frmCallTrack-Cases]!CCSSID & "'")