Query for a particular month

  • Thread starter Thread starter Kat
  • Start date Start date
K

Kat

Hi all!

I need some help trying to extract the month from a date
column. I tried using 'DatePart' but could not get it to
work. I would like to be able to choose all the records
for the month choosen when prompted. My table is set up
with the short date and the imput mask 99/99/00;0_

Any help you could give me would be greatly appreciated!

Kat
 
Month function gives you a number from 1 to 12.

Format function will extract month name:
Format([DateField], "m") gives number of 1 to 12
Format([DateField], "mm") gives number of 01 to 12
Format([DateField], "mmm") gives 3-letter abvreviation of month (Jan,
Feb, etc.)
Format([DateField], "mmmm") gives full name of month (January,
February, etc.)
 
Thanks Ken! I'll give it a try!
Kat
-----Original Message-----
Month function gives you a number from 1 to 12.

Format function will extract month name:
Format([DateField], "m") gives number of 1 to 12
Format([DateField], "mm") gives number of 01 to 12
Format([DateField], "mmm") gives 3-letter abvreviation of month (Jan,
Feb, etc.)
Format([DateField], "mmmm") gives full name of month (January,
February, etc.)

--

Ken Snell
<MS ACCESS MVP>


Hi all!

I need some help trying to extract the month from a date
column. I tried using 'DatePart' but could not get it to
work. I would like to be able to choose all the records
for the month choosen when prompted. My table is set up
with the short date and the imput mask 99/99/00;0_

Any help you could give me would be greatly appreciated!

Kat
Click to expand...


.
Click to expand...
 
Back
Top