[AccessD] A2003: Filter Property

Hi Stuart et al
Excellent - DateValue('" & Me.txtStartDate & "')" works like a charm
Next q :-))
What would the syntax be or a date range
Eg in SQL you'd write something like...
>= Me.txtStartDate and <= Me.txEndDate

How does this apply to a filter or does it not apply??

Many thanks

Darren

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, 12 November 2004 11:48 AM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] A2003: Filter Property

On 12 Nov 2004 at 11:32, Darren DICK wrote:

> Hello all
> The help wasn't very helpful
> I want to apply a filter to a form using criteria from other controls 
> like Me.Filter = "DateOfBilling = " & Me.txtStartDate Me.FilterOn = 
> true
>  
>  
> It doesn't seem to work (IE It returns no results) But I have about 20 
> records where about 6 of those records have the same DateOfBilling 
> date as I am typing into txtStartDate field
>  
> So why don't I see those 6 returned from the 20??
>  

Good old Internationalisation and date display formats strikes again?

Try
Me.Filter = "DateOfBilling = DateValue('" & Me.txtStartDate & "')"


-- 
Stuart


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com