Query - More than 15 days old!

B

Bob Vance

Between Date()-15 And Date()-200000
Is there a better way than this....Regards Bob
 
J

John Mishefske

Bob said:
Between Date()-15 And Date()-200000
Is there a better way than this....Regards Bob

Instead of using Between why not use

< Date() - 15

one comparison instead of two.


--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com
 
B

Bob Vance

Thanks John , worked perfectly..Bob

John Mishefske said:
Instead of using Between why not use

< Date() - 15

one comparison instead of two.


--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com
 
Top