>Hello,
> I try to select all the clients who have certain number in total production in a given date range. Could I use one sql statement to accomplish this task ? I do it in two steps: 1)sum up productions for all the clients. 2) select the records which have production more than a specific number. Any better idea ? Thanks.
>sherry
Sherry,
Add a HAVING clause to your SQL statement. If SUM(Items) as Total then add HAVING Total >= myvaluehere.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao