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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 3035 2
strWhere = filter 'between' syntax? 3
Excel Formula 1
Final Results 5
date range query between 2 tables 2
Maximum of Two Dates 4
inserting correct number of rows 4
Solve query? 14

Back
Top