Help with dates in Access 2010

[Lars_a]

Hi
I have aproblem I’m sure there is a simple solution to, but I don’t know how to do it.
I work for a company that manages artists, and I am building an Access 2010 database to help manage this.

The thing is that I am trying to figure out how I can register an artist with start and end date to their commitment, and to later be able to search specific dates and see who was working.

My table has: Artist Name, Start date, End date.

Let’s say Artist A. works from Jan 1^st to Jan 10^th, and I later want to run a query to see who worked on Jan 7^th.

Can anybody help me with this?

[June7]

Something like:

SELECT * FROM tablename WHERE [enter mm/dd/yyyy] BETWEEN [Start Date] AND [End Date];

This is an example of query with input parameter prompt. Run the query and an input prompt will pop up. Problem with query input parameter prompts is cannot validate entry.

[pbaldy]

If you need to check a range, this might help:

http://www.baldyweb.com/OverLap.htm

[Lars_a]

Great!! I replaced the promt with a textbox, and put into a form and that did the trick.

Thank you so much, June7.