[AccessD] date query

Lonnie Johnson prodevmg at yahoo.com
Wed Aug 16 07:50:09 CDT 2006


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 


More information about the AccessD mailing list