stevekos07
Registered User.
- Local time
- Yesterday, 18:28
- Joined
- Jul 26, 2015
- Messages
- 174
Not often I fix something but don't know why it fixed the problem. I have a table with 320,000 records. When I tried to construct a query with criteria to filter by BETWEEN dates, I only got records showing with the first date in the range. I was going nuts, when I finally decided to index the dates in the design view. This fixed the problem. I can now construct queries that behave correctly but would not before the indexing.
Can anyone explain to me why? Just for future reference.
Can anyone explain to me why? Just for future reference.