Calulating quarters from date field

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

Guest

Hello,

I can't seem to get my calendar dates to calculate as serial quarterly
numbers when I try to build my query. Access doesn't seem to recognize
"Quarter" or "Qtr".

All help is appreciated...

Joe
 
JoeAccess381 said:
Hello,

I can't seem to get my calendar dates to calculate as serial quarterly
numbers when I try to build my query. Access doesn't seem to recognize
"Quarter" or "Qtr".
Click to expand...

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

So, what are you doing that Access doesn't recognize?

Have you tried the DatePart() function?

DatePart("q", Date())

Note the "q" which means Quarter.

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

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

iQA/AwUBQk2kLIechKqOuFEgEQKQawCfYGWyrpd/bvrazsbT/gJ2N1CE7NoAoJti
KtmUwjJiWhEJk/g7NNbK+b47
=Rtno
-----END PGP SIGNATURE-----
 
Back
Top