Birth date

[Lost in Virginia]

I created a table with standard information name, Birthday, Date of Hire etc.
Now I want to create a query for birthday and break it down to month only
January, February, etc. The query part was easy but I can't figure out the
function I need to only list the months that I want. Any assistance would be
greatly appreciated.

 

[John Spencer MVP]

Add another column to the query. You can choose not to show the column.

Field: Month(BirthdayField)
Criteria: [Enter Month Number]

When prompted enter a number from 1 to 12.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[MGFoster]

I created a table with standard information name, Birthday, Date of Hire etc.
Now I want to create a query for birthday and break it down to month only
January, February, etc. The query part was easy but I can't figure out the
function I need to only list the months that I want. Any assistance would be
greatly appreciated.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Month() function around the Birthday:

Month(BirthDay)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdTbNIechKqOuFEgEQLz2ACfYVQOJf11qxhs4KHuV0Jiyph3m+cAoL9H
Z5/m/tWHcf64C5xoLVVFGGx0
=lxHS
-----END PGP SIGNATURE-----