Dsum Problem

[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:

xSumSum("[Collected]", "Passports", "[Collected]>24)

Would someone knowledgeable please help this blind person???

 

[Rob Parker]

Try:
xSumSum("[Collected]", "Passports", "Weekday([ToDaysDate])=6 And
[collected]>24")

HTH,

Rob

 

[John Spencer]

Possibly the following:

xSumSum("[Collected]", "Passports", "[Collected]>24")

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