Hello,
Here is the code in an Access 2003 module which is converting a value on a SQL Server 2005 table (tbl_ProjectSteps):
x = DCount("[Key]", "tbl_ProjectSteps", "[numProjID]=" & recCurrentTask.numProjID & " AND " & _
"CLng(Left([Key],InStr(1,[Key],'.')))=" & CLng(str_TaskID))
Here is the...