Query - More than 15 days old!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

Between Date()-15 And Date()-200000
Is there a better way than this....Regards Bob
 
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
 
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
 
Back
Top