auto updating query

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

i was wondering what i would need to use in order to
autoupdate a query beacuse the members transactions are
between 2 certain dates for example between 5/1/2002 and
3/31/2003. i want to use the day and month as permanent
days and the year from the system's year. Anyone have any
ideas how i would do that? If so please help
 
Drew

Not sure I exactly follow your description...

Are you saying you want to use a constant day and month, but have the year
be THIS year?

If so, take a look at the DateSerial() function. You can use either
constant values or expressions to get the day, month, and year components.
If I were using it to create an expression for dates falling between 5/1 of
last year (you did say "2002") and 3/31 of this year (you did say "from the
system's year"), something like the following should do it:

Between DateSerial(Year(Date())-1,5,1) And DateSerial(Year(Date()),3,31)

(actual syntax may vary)

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top