This will add hits and increment by one each time. The fields, strings and tables mean nothing but then you didn't say what you wanted counted.
my_Conn.Execute("UPDATE TableName SET HIT = HIT + 1 Where PageID =" & strPageID)
To show the hits somewhere just use:
SQL = "SELECT HIT FROM TableName WHERE PageID =" & strPageID
rs = my_Conn.Execute(SQL)
strHit = rs("Hit")
Response.Write strHit
This is the bits and pieces that will do it but you would be better off adding HIT to an existing query than using this as is.
@tomic