Access ?

[sdc1234]

I want a search query that where I enter 2 differt dates then all those people within those dates appear on a report.. example: bill, bob, bruce, buckey were gone on vacation from 9/1/11-9/55/12 I want to be able to pop in those dates and have those names pop on a report for me....... any help would be appreciated....


thank you

 

[alansidman]

In the criteria for your date field try using the Between function

ie. Between #9/1/11# and #9/5/12#
Dates need to be wrapped in hash marks.

 

[Pretty1996]

Additionally, I've used this before Between [Date1] And [Date2]

This gives a little pop up which asks the user to enter the date range manually so it's different each time.

Hope that helps,