Alternative to using Dsum function.

V

vrk1

I have a field with the following domain aggregate function that is slowing
down the time it takes to load this field. Is there any way to speeden this
up (like without
using the Dsum function?)

Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & '
1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0)
 
Top