-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could use the DatePart() function in the WHERE clause. E.g.:
....
WHERE DatePart("q", DateColumn) = 1
This will select all records where the quarter number of the value in
the DateColumn is 1.
Using DatePart() will produce a slower query, 'cuz all records'
DateColumn will have to be evaluated by the DatePart() function to
"decide" if the date is in the indicated qtr.
Or, use the Between comparison, e.g.:
....
WHERE DateColumn BETWEEN #1/1/04# And #3/31/04#
You could use PARAMETERS to refer to dates on a form instead of hard
coding the dates in the query. See the Access help articles on
parameter queries and PARAMETERS.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQJBJoIechKqOuFEgEQJdyQCZAfaRxXx6e6Ne/RnHnX1QqAGCT+UAnRRl
DI4NdkGMpYpqdKoU/rbiYy6d
=DHkA
-----END PGP SIGNATURE-----