I am having some difficulty creating a query I was hoping someone might be able to help me with.
I have two separate "Date/Time" fields in a single table, the first titled "Start Date/Time" and the second "End Date/Time". What i am trying to do is create a query to search for any dates between the start and end dates.
Example: a job starts on 10/5/12 at 1500 and ends on 10/10/12 at 0600. I want to create a query that will give me results if the search date i am searching falls between the start and end date of any existing data. Also, I only want to search the Date WITHOUT time criteria.
Hopefully this makes since.
Thanks in advance for any help.
I have two separate "Date/Time" fields in a single table, the first titled "Start Date/Time" and the second "End Date/Time". What i am trying to do is create a query to search for any dates between the start and end dates.
Example: a job starts on 10/5/12 at 1500 and ends on 10/10/12 at 0600. I want to create a query that will give me results if the search date i am searching falls between the start and end date of any existing data. Also, I only want to search the Date WITHOUT time criteria.
Hopefully this makes since.
Thanks in advance for any help.