return

Access SQL samples

Access SQL code to create parameterized date query.  The user will be prompted for dates.  The time stamp portion of the date will be ignored:

SELECT ID, DateAdded, CDate(Format([DateAdded],"mm/dd/yyyy")) AS [Date Added]
FROM Act
WHERE (((CDate(Format([DateAdded],"mm/dd/yyyy"))) Between CDate(Format([Start Date],"mm/dd/yyyy")) And CDate(Format([End Date],"mm/dd/yyyy"))));