468,791 Members | 1,799 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,791 developers. It's quick & easy.

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

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

Nov 13 '05 #1
2 1090
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
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.

Similar topics

18 posts views Thread by dfetrow410 | last post: by
67 posts views Thread by PC Datasheet | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.