Date

[Me]

I want to retrieve all records from a table where closed date < 30 days.

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

Can someone help me write query?

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

 

[Me]

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