A Date ?

[Powerdog]

I have a Schedule table with thousands of entries.
What I want to try to accomplish... is break them up in to shifts on a query...
so when I run the qeury, I first type in the name of the person...
then I want it to show me all the shifts that I have in as cryteria.
between this date and that date.

Here's an example of the table:

1/1/2005 7:00:00 AM 1/1/2005 3:30:00 PM

1/1/2005 3:30:00 PM 1/1/2005 11:00:00 PM

1/1/2005 11:00:00 PM 1/2/2005 7:00:00 AM
[There is a space between the Date and Time, the Time and the am/pm, and also the Start time and End time]

If I want to just show 3:30:00 PM to 11:00:00 PM...on a qeury... how would I do that.... without the dates being involved.
That way I can... say...
look back over a 2 week period and see those shifts for that person.
The Date and Time are in the same field...
I know how to use certain "Date" cryteria...
and to make the qeury ask for the name.
stuff like that...but I couldn't find any reponse in the archives...
And this one is beyond my capability.
I really do thank you alot in advanced...

 

[Andrew Fergus]

Hi
In your query use the TimeValue([your field name]) function. This returns just the time. In your criteria for under this field you can then enter something like >=#15:30:00# And <=#23:00:00#. Note the use of the 24 hour clock.
HTH, Andrew.