I wondered the same thing. I even had my boss look at it, and tried it in access. My boss was the one who suggested the final combining. It worked in Access and I've done the same thing in FoxPro and VFP...
go figure
Thanks for all your help,
I hope we all go into the weekend well...
Rick
>Rick,
>
>
>It wasn't until I set the WHERE clause up as
>>>>WHERE ((Activities.Schedl_For = 26) AND (Activities.Start_Time > 6/17/2004))
>> OR ((Activities.Schedl_For = 26) AND (Activities.Start_Time >= 5/25/2004 AND Activities.Start_Time < 5/26/2004))
>>
>>That I got
>>the 1 record for the 5/25/2004
>>and the 1 record for the future
>>
>>Seemed strange to me.... oh well>
>Wow, that seems weird to me too. You shouldn't have had to combine the Schedl_For with the dates like that. I wonder if you had your parentheses wrong somewhere and didn't realize it? (although they look fine in your example).
>
>~~Bonnie
>
>
>
>>One more item along this line of thought... (ignoring TIME stuff)
>>
>>My WHERE clause that I was building,
>>>> WHERE (Activities.Schedl_For = 26)
>>>> AND (Activities.Start_Time = 6/17/2004)
>>is intended to return work done in a date range for a specific user_ID (stored in Activities.Schedl_For)
>>The date range could be:
>>All
>>Today
>>Past
>>Future
>>or between a Start and End date
>>
>>When the WHERE clause was
>>
>>WHERE (Activities.Schedl_For = 26)
>> AND (Activities.Start_Time > 6/17/2004)
>>
>>It returned the 1 record for the future
>>
>>
>>When the WHERE clause was
>>
>>WHERE (Activities.Schedl_For = 26)
>> AND (Activities.Start_Time >= 5/25/2004 AND Activities.Start_Time < 5/26/2004)
>>
>>It returned the 1 record for the 5/25/2004
>>
>>
>>When the WHERE clause was
>>
>>WHERE (Activities.Schedl_For = 26)
>> AND ((Activities.Start_Time > 6/17/2004)
>> OR (Activities.Start_Time >= 5/25/2004 AND Activities.Start_Time < 5/26/2004))
>>
>>It returned the 1 record for the future
>>
>>It wasn't until I set the WHERE clause up as
>>
>>WHERE ((Activities.Schedl_For = 26) AND (Activities.Start_Time > 6/17/2004))
>> OR ((Activities.Schedl_For = 26) AND (Activities.Start_Time >= 5/25/2004 AND Activities.Start_Time < 5/26/2004))
>>
>>That I got
>>the 1 record for the 5/25/2004
>>and the 1 record for the future
>>
>>Seemed strange to me.... oh well
>>
>>
>>Rick
>>