[AccessD] date query

Hello Lonnie and Bobby,

thanks for the help.

Pedro


----- Original Message ----- 
From: "Lonnie Johnson" <prodevmg at yahoo.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, August 16, 2006 2:50 PM
Subject: Re: [AccessD] date query


> SELECT Rapnaam, Datum1, Datum2
> FROM BVO
> WHERE Datum2>[Datum1]+10
>
> pedro at plex.nl wrote:  Hello Group,
>
> it has been a long time since my last participation on this group, but now 
> i have a question.
>
> I have a table (BVO)
> with three fields [Rapnaam]=text field[Datum1]=date field [Datum2]=date 
> field
>
> I need the records of which the date of [Datum2] is later then 10 days 
> from [Datum1], per Month.
>
> Thanks
>
> Pedro Janssen
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
> May God bless you beyond your imagination!
> Lonnie Johnson
> ProDev, Professional Development of MS Access Databases
> Visit me at ==> http://www.prodev.us
>
>
>
>
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>