where condition

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

Guest

I am trying to set a value to a field based on a contion that the date given is between two given dates.... is it possible and please how???
 
At100,

Yes this is certainly possible. The specific details of how to do it
will depend on what, when, where of your situation. But the basis of
your condition will be something like this...
[GivenDate] Between [FirstDate] And [SecondDate]
If, as I understand it, the date range is fixed dates, like this...
[GivenDate] Between #1/01/2004# And #30/06/2004#
Or, if it is in a variable range depending on current date, for example
the last 90 days, like this...
[GivenDate] Between Date()-90 And Date()

You will possibly use a macro using the SetValue action. Or you may use
an Update Query. Or there may be other options as well, asregards
methodology.
 
Back
Top