[AccessD] [SPAM SUSPECT] Re: date query

Try something like:

SELECT * 
	FROM BVO 
	WHERE datediff("d",[Datum1],[Datum2])>10

You might have to switch the dates, I can't remember at the moment the
proper order.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: Wednesday, August 16, 2006 8:50 AM
To: Access Developers discussion and problem solving
Subject: [SPAM SUSPECT] Re: [AccessD] date query
Importance: Low


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