oh.. thank you.. i have a follow up question, what if i have a parameters. example: select count(name) from employees where position = "associates" how can i apply this to dcount function? "Douglas J. Steele" wrote: Simplest approach would be to use the DCount function. Set the ControlSource property of the text box to =DCount("*", "Employees") Include the equal sign

Sorry, can not help you. -- KARL DEWEY Build a little - Test a little "Syrel" wrote: Here's an example code: sSQL = "Select actionqueue from dpldata where actionqueue = 'Reject'" Call DbConn rs.Open sSQL, Dbase, adOpenForwardOnly, adLockOptimistic If rs.RecordCount 0 Then rs.MoveFirst i = 0 Do While Not rs.EOF i = i + 1 rs.MoveNext

Here's an example code: sSQL = "Select actionqueue from dpldata where actionqueue = 'Reject'" Call DbConn rs.Open sSQL, Dbase, adOpenForwardOnly, adLockOptimistic If rs.RecordCount 0 Then rs.MoveFirst i = 0 Do While Not rs.EOF i = i + 1 rs.MoveNext Loop TxtDReject.Value = i End If Call RsClose Call DbClose THe rs.recordcount has a value of -1 eventhough