restricting date query

  • Thread starter Thread starter david kennedy
  • Start date Start date
D

david kennedy

I am having problem creating a query without an error. I
use access 2000 and windows 2000. Two fields are
[mailing1] and [mailing2]. Mailing1 occurred over a
number of different days.

I want to send out a mailing which is anything more than
21 days after the first mailing. The following criter is
in maiing1: isnotnull and <[mailing1]-21 while
[mailing2] is null. It doesn't work. Syntax help would
be appreciated.

I am unfamiliar with programming language and if the
solution is available within query criteria, same would
be appreciated.
 
David,

Well I can see why it doesn't work as you have it, because with your
criteria you are in fact asking for "all records where the entry in the
Mailing1 field is 'before 21 days before' the entry in the Mailing1
field", which of course is impossible. But now I am not sure what to
advise, because I can't really understand "anything more than 21 days
after the first mailing". Do you mean where Mailing1 was more that 21
days ago, i.e. more then 21 days before the current date (today)? If
so, try the criterion <Date()-21 otherwise maybe you could give some
examples which might make your meaning clearer. Thanks.
 
Back
Top