There are a number of other fields associated with this individual other than visit number that complicates the db. It has to be this way and can't be normalized.
Any ideas sin normailzation?
I am trying to create a field (either in my original table or in a query) that automatically fills in the visit number for each individual, so when an individual makes a subsequent visit, the visit# will automatically fill in.
ie:
IND VISIT#
a 1
a 2
a 3
b 1
b 2
c 1
...if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.