Code: Select all
7Day: Val(DCount("*","tblAdmissions","PatientID=" & [PatientID] & " And Visits>" & [Visits] & " And Admitted Between #" & Format([Discharged],"mm\/dd\/yyyy") & "# And #" & Format([Discharged]+7,"mm\/dd\/yyyy") & "#"))
Code: Select all
7Day: Val(DCount("*","tblAdmissions","PatientID=" & [PatientID] & " And Visits>" & [Visits] & " And Admitted Between #" & Format([Discharged],"mm\/dd\/yyyy") & "# And #" & Format([Discharged]+7,"mm\/dd\/yyyy") & "#"))