Distinct Count

[ertweety]

Need some help on distinct counting. Would like to distinctly count the call_end_tm_seq field. Help!

SELECT DateValue([CALL_DT]) AS THE_DATE, Count(tbl_NBLD_OUTBOUND_CALL_DATA.CALL_END_TM_SEQ) AS LIVE_DIALS_ENG
FROM LIST_ID INNER JOIN tbl_NBLD_OUTBOUND_CALL_DATA ON LIST_ID.LIST_ID = tbl_NBLD_OUTBOUND_CALL_DATA.CALL_LIST_ID
WHERE (((LIST_ID.LIVE_ENG)=1))
GROUP BY DateValue([CALL_DT]);

[June7]

Why does this query fail to return what you want? What is relationship of the tables?