M
Matt
I am having trouble with date criteria slowing down my query response time.
If I hardcode my date in my query it comes back instantly.
example:
WHERE (((LWMAIN.DATE_REPT)=#8/22/2006#));
When I put an expression in the Criteria or link to a Access Date field in a
table or form my reponse time takes approx 60 seconds.
examples:
WHERE (((LWMAIN.DATE_REPT)=[Enter Date]));
WHERE (((LWMAIN.DATE_REPT)=[forms]![frmDate]![Date]));
WHERE (((LWMAIN.DATE_REPT)=Date()-3));
Is there anything I can do about this?
If I hardcode my date in my query it comes back instantly.
example:
WHERE (((LWMAIN.DATE_REPT)=#8/22/2006#));
When I put an expression in the Criteria or link to a Access Date field in a
table or form my reponse time takes approx 60 seconds.
examples:
WHERE (((LWMAIN.DATE_REPT)=[Enter Date]));
WHERE (((LWMAIN.DATE_REPT)=[forms]![frmDate]![Date]));
WHERE (((LWMAIN.DATE_REPT)=Date()-3));
Is there anything I can do about this?