Improved Response Time

  • Thread starter Thread starter Michel Walsh
  • Start date Start date
M

Michel Walsh

hi,


Use a total query?

SELECT CreatedBy, COUNT(*)
FROM qryName
WHERE createdDate BETWEEN DateFrom AND DateEnd
GROUP BY CreatedBy


and eventually make the appropriate joins with the actual query/table you
use for the record source of the form, if this is appropriate...


Hoping it may help,
Vanderghast, Access MVP
 
TGIF,
As the arrival of New Year, I need to provide some
Statistics, like "How many requests John Doe handled last
year". I run a DCount function in a query:
=DCount "[qryId]","qryName","[CreateDate] >= #" &
DATE_FROM & " # AND [CreateDate] <= # " & DATE_END & " #
AND [CreatedBy] = '" & John Doe & " ' ").
The respone time is a little slow, how can I improve ?
If I index CreateDate & CreatedBy will that help?
Thanks for your kindly input.
 
Back
Top