Hello. I'm writing a query to show if it is past 7 days of a certain date. The field in my table is SentDate. Lets say a package was sent on 2/1/05. If it is past 7 days from that date, I need the query to show this. I come up with
=Now()>"[Tablename]"!"[FieldName]", I know all this shows is if today is greater than the day sent, but I just need to know where I would add the +7 days line to it, or if I cant add that to this particular line, could anyone give me a hint as to what it would be?
=Now()>"[Tablename]"!"[FieldName]", I know all this shows is if today is greater than the day sent, but I just need to know where I would add the +7 days line to it, or if I cant add that to this particular line, could anyone give me a hint as to what it would be?