I'm trying to extract a number of rows of data from a large table based on a date/time field. I want to extract all the data for one year into a new table. The field contains both a date and a time in the format dd/mm/yy hh:mm:ss. To extract all of year 1995, for example, I need to specify some sort of wild card in the form */*/95 *:*:*. I have not been able to do this. Any suggestions?

Look up the DatePart function
HTH

Thanks, I've now set criteria to: <31/12/95 23:59:00 which has done the trick.