By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Functions - Is there a function for 'between'

100+
P: 167
I do not see any but thought I would ask anyway... is there a function that canc be used to check for a value being 'between' 2 values? I know in sql for Oracle I could use "IF mydate between (date1, date2)".
Thanks
Mar 5 '08 #1
Share this Question
Share on Google+
1 Reply


MindBender77
100+
P: 234
I do not see any but thought I would ask anyway... is there a function that canc be used to check for a value being 'between' 2 values? I know in sql for Oracle I could use "IF mydate between (date1, date2)".
Thanks
You can use "Between" in Access sql. Ex.
Expand|Select|Wrap|Line Numbers
  1. Select field1, Field2 from YourTable where Field1 between #02/01/2008# and #02/29/2008#
  2.  
Bender
Mar 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.