troubleshooting Question

MS Access SQL - Imbedding dates into queries from form fields

Avatar of andyb7901
andyb7901 asked on
Microsoft AccessSQL
10 Comments1 Solution222 ViewsLast Modified:
I am trying to develop a query where I delete all records between two dates. I need to take these dates from two text fields on my form. The field in the database that it is comparing the text field to is a Date, so I need to imbed the # somehwere in my query. Can anyone help;

DELETE tbl_MIS_Records.*
FROM tbl_MIS_Records
WHERE (((tbl_MIS_Records.[Signature Time]) Not Between [Forms]![frm_KYC_Lookup]![txtStartDate].[text] And [Forms]![frm_KYC_Lookup]![txtStartDate].[text]));

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros