View Full Version : Search between dates


thingssocomplex
03-09-2009, 01:15 PM
Hi Guys,

I am hoping somebody can share some wisdom! I have a date field within a table and I want to be able to search within a date range using a form, for instance a user will enter a date in two boxes 'From' & 'To' and this will then return results of data I hold in a table for them dates.

Can somebody please lead me in the right direction please?

Many thanks

John Big Booty
03-09-2009, 04:08 PM
Try;


Between [Forms]![FormName]![FromDate] And [Forms]![FormName]![ToDate]