Dummy proof date search

[Simpleton]

Gentlemen,

How can I set up a field that contains dates (xx/xx/xxxx)

so I can enter month, day or year,and get a match?

ie...enter "1995" and see records containing 01/01/1995 - 12/31/1995.

Thanks.

[Kurt Knippel]

Make a seperate TEXT field containing something like the following:

code:

---

Month ( Date ) & "/" & Day ( Date ) & " " & Year ( Date )

This will seperate the "date" into different parts which can then be searched for independantly.