Recent content by DinanS2

I'm just learning how to use VBA in Access that's why I am here. I retired from the US Navy after 28 years, stayed home for nine months then found a new hobby. Hope to learn a lot from this forum.

First create a function: Function PersTimely(ByVal SFID As String, ByVal sDATE As String, ByVal eDate As String) PersTimely = DCount("TRANSACTION", "MASTERDTL", "ET < " & 10 & " AND STATUS <> '" & "Reject' AND " & "TRANSACTION LIKE '" & SFID & "*' AND POSTDT BETWEEN #" & sDATE & "# AND #" &...