Search results

Never mind. I just limited the data to one person and it worked. I forgot and attempted to change it back and run the query again. Then I received the error on the same "patient1 =" line. sorry Tyler

It turns out I was trying to moveNext and did not check for EOF. Now the only problem is that the function does not return a value when put into a query. Any ideas? Thanks, Tyler here is the new code Public Function dateStart() As String Dim db As Database Dim rst1 As...

I am attempting to create a function that will determine the minimum and maximum dates within a patients length of stay. for example: Patient StartDate EndDate pat1 1/1/2009 1/3/2009 pat1 1/4/2009 1/6/2009 pat1 2/15/2009 2/20/2009 The result would be that one function gives the...