Prev: SQL BETWEEN If end date is less than start date all records betweenare still displayed.
Next: SQL BETWEEN If end date is less than start date all recordsbetween are still displayed.
From: Marshall Barton on 3 Apr 2010 09:23
Avid Fan wrote:

>I noticed that this query shows records the records between even if the
>second date is larger than the first.
>
>No big deal really I just was not expecting it.
>
>I suppose you have to code around it in case somebody makes a mistake.
>

Between doesn't care which one is earlier. If it matters to
you, don't use Between. Instead use something like:

datefield >= startdate And datefield <= enddate

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: SQL BETWEEN If end date is less than start date all records betweenare still displayed.
Next: SQL BETWEEN If end date is less than start date all recordsbetween are still displayed.