I'm developing an Access application with Access as the front end and using SQL Server as the back end database.
I am accessing an Access table named tblAccounts with a field titled DateLost defined as varchar(30). It is comprised of dates in the format mm/dd/ccyy (for ex: 05/25/2007).
How would you extract records from this table named tblAccounts that are in the range
of dates within the prior month ?
In other words, if I run the report in June 2007, I want to extract records from ONLY the month
of May 2007 (05/01/2007 through 05/31//2007) ?