>
> When I run the following query I get no rows returned:
>
> select
> s.del_date, s.account_id, sum(s.qty) as Total
> from
> sale_mdse_ru s
> where
> (s.del_date = '2/20/2002') and
> (s.account_id in (1)) and
> (s.dept = 671)
> group by
> s.del_date, s.Account_id

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.

HTH
Woody (TMW)