var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Using between operator
What is the most widely expected way for a user to enter a starting and ending range for a report?
If I use the SQL statement, Between Appleman and Greer, the results would be:
Greer would not be included in the set.
If I take the Gr from Greer and make the r an s (the next character) then Greer gets included in the search results.
Maybe I'm making this too complicated. But you get the point.
Using Access 2k3.
I tried this query and i have this result :
WHERE (((Table1.Champ1) Between 'Appleman' And 'Greer'));
Where is your problem ?
Was away for several days. Just catching up. It turned out my test was flawed and thus gave me bad results. The search worked as it should have after all.
Thank you both for the help.