Today's date + 21 days

  • Thread starter Thread starter Pyrite
  • Start date Start date
P

Pyrite

Hi,

I have a query to highlight if I have sent a form to someone and not heard
anything back. There is a date sent and also a 'returned' which is completed
by an option group so is 1 for yes and 2 for no. I have the criteria of "2"
on the returned column so only displayed if not returned.

My problem is that I only want results displayed if it has been more than 3
weeks since I sent the form out hence I need <Date()+21 but that doesnt work
it just displays them if the date sent is smaller than todays date.
 
WHERE Returned = 2 AND DateSent+21 < Date()

But what happens if someone decides to *never* get back to you? In such a
case, their record will always be returned to you. You need a way to say
"they haven't got back to me, but I don't want to see their record any
more".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thanks for the response Graham,

I have already thought of the other scenario of no return. I am basically
going to ring people up after the three weeks and speak to them so the
returned record is actually more like responded so once I have spoken to them
I will mark them as 'Repsonded'.

Thanks again for your time Graham
 
Yes, you're right, but I think you mean...
AND DateSent > Date() - 21

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
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.
 
Ignore the last, I have just done it in the SQL view as you obviously
originally intended.
 
Graham said:
Yes, you're right, but I think you mean...
AND DateSent > Date() - 21
Click to expand...

I don't think so.

DateSent + 21 < Date()

....is equivelant to...

DateSent < Date() - 21

Isn't it? If he needed a less-than before he should still need a less-than.
We're just moving the calculaton to the other side of the operator.
 
Yes, yes, yes, yes. Sorry Rick. I don't know what I was thinking.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top