Thread: Delete query - Access
June 1st, 2011, 07:38 PM #1
- Join Date
- Jun 2011
Delete query - Access
Trying to build a delete query. Starting it out as a select to make sure its pulling the correct data. I know it should pull 1 row. Here is the SQL.
SELECT Site_Notes.Store_Nmbr, Site_Notes.Store_Note, Site_Notes.Store_Note_User, Site_Notes.Store_Note_Date
WHERE (((Site_Notes.Store_Nmbr) In (select site_tracking.store_nmbr from site_tracking where site_tracking.site_complete = yes)) AND ((Now()-[Site_Notes].[Store_Note_Date])>720));
When I remove the "where site_tracking.site_complete = yes" from the WHERE clause it works but I need that criteria. Ideas?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By jaycee149299 in forum Technical SupportReplies: 0Last Post: January 17th, 2009, 12:30 AM
By [Neo770] in forum Applications and Operating SystemsReplies: 9Last Post: May 29th, 2007, 09:30 PM
By Marvinator in forum Applications and Operating SystemsReplies: 2Last Post: December 2nd, 2003, 03:24 PM
By kickzum in forum Applications and Operating SystemsReplies: 6Last Post: August 30th, 2002, 05:28 PM
By SlipGun in forum Webmastering and ProgrammingReplies: 9Last Post: April 15th, 2002, 09:24 PM