I've got a database of clients and I want to be able to search for employees
by their birth month. I have a field named [Date of Birth] that is in
Date/Time format. I want to be prompted to enter a number for the month. For
example, when I run the query, I want to be asked to put in 08 for August and
have it bring up all the employees born during August.

Thanks!

Answered in your post 4 minutes later.

--
Rick B



"Sara" <(E-Mail Removed)> wrote in message
news:B60BAF05-E50C-4E4E-A49F-(E-Mail Removed)...
> I've got a database of clients and I want to be able to search for
> employees
> by their birth month. I have a field named [Date of Birth] that is in
> Date/Time format. I want to be prompted to enter a number for the month.
> For
> example, when I run the query, I want to be asked to put in 08 for August
> and
> have it bring up all the employees born during August.
>
> Thanks!

Answered in your post 3 minutes later.

Ya'll that was an accident that I posted so many times......I'm using my
friend's computer and it started locking up and I didn't realize that my
question had already gone through. SORRY!

"Allen Browne" wrote:

> Answered in your post 3 minutes later.
>
>
>