SELECT *
FROM enrollments
WHERE verify = 'Yes' AND return_date > #DateAdd("d", -14, now())#
ORDER BY enroll_num ASC
Thanks to those that replied!!!
This is using Access by the way. Switching to SQL Server in a few weeks...
--
Les Mizzell
-------------------------
�Mihi placent, O Pincerna!
Virent ova! Viret perna!
Dapem posthac non arcebo.
Gratum tibi me praebebo.�
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
