Month Format

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Can you help me format a field in a Query that not only
displays the Month (versus the actual Date), but can also
be sorted by Month for reporting? I am able to display
the month, but when I sort the query it lists the month
several times, one for each actual date, even though only
the month name is displayed.
 
Mary said:
Can you help me format a field in a Query that not only
displays the Month (versus the actual Date), but can also
be sorted by Month for reporting? I am able to display
the month, but when I sort the query it lists the month
several times, one for each actual date, even though only
the month name is displayed.
Click to expand...

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

Something like this:

ORDER BY Month(DateColumn)

Change the name of the date column to your table's column name.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQIQwlIechKqOuFEgEQKZuwCePE/mB51/Dt23wMCY15zUwRzL6xYAoMXV
RseR/nAFHOKBA88Py0nOhnHw
=Xqmo
-----END PGP SIGNATURE-----
 
Back
Top