Dsum Problem

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have a query that counts the number of items for each day of the week using
this code:

xFri: Count(IIf(Weekday([ToDaysDate])=6 And [collected]>24,1,Null))

I’m trying to get a total value of those records using this code:

xSum:DSum("[Collected]", "Passports", "[Collected]>24)

Would someone knowledgeable please help this blind person???
 
Try:
xSum:DSum("[Collected]", "Passports", "Weekday([ToDaysDate])=6 And
[collected]>24")

HTH,

Rob
 
Possibly the following:

xSum:DSum("[Collected]", "Passports", "[Collected]>24")

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