help in writing query in access

[Guest]

I have a need to write a query with a linked table to sql server from a table.

like select ponumber, closeddate from po
where closeddate < 30days from today's date.

Thank you,
-Me

 

[Rick B]

Please don't post copies of your message in other groups. You don't need
people to spend time answering your question only to find tat someone else
might have already responded in another newsgroup.

Have you done a search? This is a very common question.

http://groups-beta.google.com/groups?q=microsoft.public.access.queries+"days+from+now"


Rick B

 

[Guest]

Rick,

First I posted in general discussion and then I realized that I should have
posted
it on Access Queries group, that's why I posted it there again.

I am sorry if you had to spend a bit too much time.

Thanks much,
-Me

 

[John Spencer (MVP)]

SELECT PONumber, ClosedDate
FROM PO
WHERE ClosedDate < DateAdd("d",-30,Date())

You can adjust the -30 as needed to be a different number or positive.