How do I set a between criteria in a query in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Specifically, I tried a criterial selection of between July and December. I
have a month field and a year field. In the year field I had 2005. I did not
get the results I wanted.
 
That's because you typed the month name (July) rather than converting your
date to a month number and comparing to the number 7.
 
How do I convert the month to a number?

Duane Hookom said:
That's because you typed the month name (July) rather than converting your
date to a month number and comparing to the number 7.
Click to expand...
 
One method:
1) backup your database
2) open the table in datasheet view
3) place your mouse in the month text field
4) select Edit->Find and Replace
5) replace all "January" with 1
6) do #5 for Feb-Dec
7) change the field type to integer
 
Back
Top