select sum(time_hr),sum(time_mi) from timesheet where wtid=1 and workdate between #24-July-2006# and #28-July-2006# and projid in (select Proid from ProjectMaster where ClientID in ( select ClientID from ClientMaster where team = "& objRs(3) &"))

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Select Criteria fields in query first then set the conditions. Then errors can be traced out.

Ashfaque

I didn't get your answer can u pls be more specific?

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.