how to query by a date range?

[dmbfan715]

Hi,

I just discovered this site today! It's wonderful. I'm making a database at work and need help with a query. I'm trying to pull records within a date range: (user inputed date till the of the year). Is there an easy way to do this? Thanks in advance!

 

[nabiS2K]

Sure.

You can use the Between command like this:

=Between [UserInputDate] And DateValue("12/31/" & Year(Date))

Paste this into the criteria of the date field in a query and see if it works like you want.
God Bless
Mike ;-)

 

[dmbfan715]

Hi Mike,

Thanks for the speedy response. I'll try it out. =)

Shivani