date formulas

[BillyRogers]

I have several queries that are run once each month with date fields that
have to be changed. I have tried replacing the actual dates with functions
and formulas, but they all slow the queries down way too much to be of any
use.

I tried using this in place of #12/1/2005#

DateSerial(Year(Date()),Month(Date())-2,1)

with the date typed in the query takes 2 minutes. with the formula i stopped
it after 6 minutes.

I have queries that I have to run to build reports where i have to change 20
dates. It would be so nice if I could just put in a formula instead on
having to change the dates each month.

most of the dates follow a pattern like fist day of last month, two months
ago or last day of previous month, two months ago etc.

I don't understand why the funtions and formulas are so slow?
--
Billy Rogers

Dallas,TX

Currently Using Office 2000

 

[Larry Daugherty]

How about resolving the date on a form before you call the reports?
Have the query for the report refer back to the control on the form.

HTH

 

[John Spencer]

How about posting the SQL of one of these queries? That may help someone
spot the cause of the problem.