DCount returning Zero

  • Thread starter Thread starter EddieL
  • Start date Start date
E

EddieL

Can anybody advise as to why the DCount is returning Zero for this query?

SELECT DatePart("yyyy",[xDateIssuedtoSC]) AS ayear,
DatePart("ww",[xDateIssuedtoSC]) AS amonth,
Sum(DCount("[x]","x_tbl_dates",DatePart('ww',[xDateIssuedToSC])="amonth")) AS
RunTot, DatePart('ww',[xDateIssuedToSC]) AS Expr1
FROM x_tbl_dates
GROUP BY DatePart("yyyy",[xDateIssuedtoSC]),
DatePart("ww",[xDateIssuedtoSC]), DatePart('ww',[xDateIssuedToSC])
ORDER BY DatePart("yyyy",[xDateIssuedtoSC]), DatePart("ww",[xDateIssuedtoSC]);
 
Try this modification to your criteria.

DCount("[x]","x_tbl_dates","DatePart('ww',xDateIssuedToSC)=" &
DatePart("ww",[xDateIssuedtoSC]))

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top