Re: Today's date + 21 days

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ignore the last, I have just done it in the SQL view as you obviously
originally intended.

"Pyrite" wrote:

Hmm,

I am trying to implement this is the design view of the query on the
criteria line. I cant seem to get it to work. Where would I write your
statement?

I currently have "2" in the cirteria line underneath 'returned'. What would
go in the criteria line underneath 'Date Sent'? I know they need to go on the
same criteria line to be an AND statement.

"Graham R Seach" wrote:

Yes, you're right, but I think you mean...
AND DateSent > Date() - 21

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:t1syk.94$ZP4.40@xxxxxxxxxxxxxxxxxxxxxxx
Graham R Seach wrote:
WHERE Returned = 2 AND DateSent+21 < Date()

Better (performance-wise) would be...

WHERE Returned = 2
AND DateSent < Date() -21

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com




.

Relevant Pages

  • Re: Todays date + 21 days
    ... Graham R Seach ... Microsoft Access MVP ... DateSent + 21 < Date ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... AND DateSent> Date- 21 ... Graham R Seach ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... go in the criteria line underneath 'Date Sent'? ... "Graham R Seach" wrote: ... AND DateSent> Date- 21 ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Yes/No Query
    ... All you have to do is enter True or False into the Criteria box. ... Graham R Seach ... Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... Graham R Seach wrote: ... DateSent + 21 < Date ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)