I would like to only sum the fields which equal a criteria that fall within a certian date.

[david.isaacks]

I would like to only sum the fields which equal a criteria that fall
within a certian date.

=Sum(Abs([Status]="Normal", '>=#7/1/2006# And <#8/1/2006#'))

Also would like to count in the same fashion?

Thanks,
David

 

[david.isaacks]

=DCount("[Completed]","Calls","[Monitor Date] = '>=#7/1/2006# And
<#8/1/2006#'")

Completed is a Check box field, calls is the table name.

 

[david.isaacks]

=DCount("[Completed]","Calls","[Monitor Date] BETWEEN #7/1/2006# And
#8/1/2006#'")

Ok I got this to work for the count.

=DCount("[Completed]","Calls","[Monitor Date] = '>=#7/1/2006# And
<#8/1/2006#'")

Completed is a Check box field, calls is the table name.

I would like to only sum the fields which equal a criteria that fall
within a certian date.

=Sum(Abs([Status]="Normal", '>=#7/1/2006# And <#8/1/2006#'))

Also would like to count in the same fashion?

Thanks,
David

 

[Duane Hookom]

Don't use a domain function. Try:
=Sum(Abs([Status]="Normal" AND [Monitor Date]>=#7/1/2006# And [Monitor
Date]<#8/1/2006#))

=Sum(Abs([Completed]=True And [Monitor Date] >=#7/1/2006# And [Monitor
Date]<#8/1/2006#))

These are actually counts, not sums.

 

[david.isaacks]

Works perfect! Great.
David

Don't use a domain function. Try:
=Sum(Abs([Status]="Normal" AND [Monitor Date]>=#7/1/2006# And [Monitor
Date]<#8/1/2006#))

=Sum(Abs([Completed]=True And [Monitor Date] >=#7/1/2006# And [Monitor
Date]<#8/1/2006#))

These are actually counts, not sums.

--
Duane Hookom
MS Access MVP

I would like to only sum the fields which equal a criteria that fall
within a certian date.

=Sum(Abs([Status]="Normal", '>=#7/1/2006# And <#8/1/2006#'))

Also would like to count in the same fashion?

Thanks,
David