dateadd expression in a query

B

BigG

I am trying to set a critera in an access 2000 update query that returns all
the records which have not been ordered for two months exactly.

Can anyone help?
 
J

John Vinson

I am trying to set a critera in an access 2000 update query that returns all
the records which have not been ordered for two months exactly.

Can anyone help?
Click to expand...

For... the past two months, prior to today? What table do you want to
update? How are your Orders stored?

Making some guesses:

SELECT <whatever> FROM <some table>
WHERE NOT EXISTS (SELECT OrderID FROM Orders WHERE OrderDate >
DateAdd("m", -2, Date()) AND OrderDate <= Date() AND Orders.ProductID
= <some table>.ProductID );


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
DateAdd and Month functions 7
Query criteria based on a Check box 8
Adding data to MS Access from csv file 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
dates and Between 3
Using DateAdd and IIF conditions in a Query 2

Top