Stuart McLachlan
stuart at lexacorp.com.pg
Thu Nov 11 19:03:25 CST 2004
On 11 Nov 2004 at 19:51, Susan Harkins wrote: > If the delimiters are the problem as Stuart suggests, you should be able to > use the following: > > Me.Filter = "DateOfBilling = #" & Me.txtStartDate & "#)" > Nope, Darren's an Aussie. Doing it that way gets the month and day reversed if he is using the default short date (today is 12/11/04, not 11/12/04 to us) and doesn't work at all if he using something like "12 Nov 04" :-( -- Stuart