Working on a MS access. Between date formula

[JP Roy]

I am pretty new at Ms Access but need to create a query that will return a value if today's date is between a Start Date and End Date fields of my database. I am creating a database that I can query and will return the name of persons who are on call between Start and End date. Can someone help Me.

[Jonesy41]

assume your start date (sd) and end date (ed) are entered on a form called entry. Use the following criteria in your query in your on call date filed:

between [forms]![entry]![sd] and [forms]![entry]![ed]