hello Frns
I am trying to retrive data from MS Acess databse by Date. My date field is in the following format in my table (MM/DD/YY) i want to sort the records based on year and month ie i want to use the date and year in my WHERE clause does ne 1 know to do this i have to use the date format that is already present kindly help
URGENT Amit