date formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
How about posting the SQL of one of these queries? That may help someone
spot the cause of the problem.
 
Back
Top