using dcount

[jjmclell]

Hi there,

Should be a simple question...when I use DCount in query builder, do I need to be in aggregate mode? I did a DCount without turning on aggregate functions, and the resulting query looks correct but there's a weird display lag in the query, i.e. when I scroll down the data table, the data doesn't show up right away and kind of trickles down from the top. I'm just wondering if there's some weird implication of not being in aggregate mode when I run the DCount.

jjmclell

 

[namliam]

No need for aggregate mode. DCount is simply SLOOOOOOOOOOOOOOOW to the max.

You should minimize the use of Dcount if you can in any way, i.e. Use a aggregate query instead...