At 26/02/2002 12:02 PM, you wrote:

>At 2/26/2002 09:46 AM, you wrote:
> >If you are using DateTime fields, it may not find an exact match because of
> >the time factor involved. That's why using a range of the date works but the
> >exact match doesn't. I always make sure I use only the date portion when
> >setting fields so I don't have this problem.
>
>That was my thinking as well. However, leaving the date part of the where
>clause as is and only changing the number of account id's returns the
>correct info, so it seems that the date part was able to be matched.
>

What happens if you put "s.account_id=1", instead of "s.account_id in (1)"?



Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)