By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,780 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,780 IT Pros & Developers. It's quick & easy.

Doing a Find on a Range of Dates in a Date field?

P: n/a
How do you do a find on a range of Dates in a Date field from the find
dialog box?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Randy wrote:
How do you do a find on a range of Dates in a Date field from the find
dialog box?


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

Instead of find you can Filter for the dates by using the Filter for:
option. How?

On the form, datasheet, open table:
1) Right click on the date field.
2) To the right of the Filter for: option enter something like this:

between #1/5/05# and #1/31/05#

then hit the enter key.

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

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

iQA/AwUBQjCBEoechKqOuFEgEQJtdACgtPMaKmh7RqKbK3oONb/nOnWXIcAAoJzE
csyfQX1z4OCsObPocjhHKdbk
=Npdp
-----END PGP SIGNATURE-----
Nov 13 '05 #2

P: n/a
Randy wrote:
How do you do a find on a range of Dates in a Date field from the find
dialog box?


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

Instead of find you can Filter for the dates by using the Filter for:
option. How?

On the form, datasheet, open table:
1) Right click on the date field.
2) To the right of the Filter for: option enter something like this:

between #1/5/05# and #1/31/05#

then hit the enter key.

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

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

iQA/AwUBQjCBEoechKqOuFEgEQJtdACgtPMaKmh7RqKbK3oONb/nOnWXIcAAoJzE
csyfQX1z4OCsObPocjhHKdbk
=Npdp
-----END PGP SIGNATURE-----
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.