creating a flag to identify first, second time etc someone has app
in [Queries]
|
Prev: Help with Query to find Month
Next: creating a flag to identify first, second time etc someone hasapp
From: helpreq on 19 Apr 2010 17:30 Hi, If I have a dataset showing the same person three times, on three different dates but want to create a flag (as below) which states whether this is the first time this person has appeared in my dataset and so on - how would I be able to do so? e.g Name date of procedure time of procedure flag john smith 15/10/2009 09:30 first procedure john smith 20/11/2009 10:30 second procedure john smith 28/12/2009 10:30 third procedure Many thanks in advance
From: KARL DEWEY on 19 Apr 2010 18:06
You need to combine the data in [date of procedure] and [time of procedure] into a single DateTime field. I suggest using a number datatype for the flag field then an update query could add to the maximum flag for the person. -- Build a little, test a little. "helpreq" wrote: > Hi, > > If I have a dataset showing the same person three times, on > three different dates but > want to create a flag (as below) which states whether this is the first time > this person has appeared in my dataset and so on - how would I be able to do > so? > > e.g > > Name date of procedure time of procedure flag > john smith 15/10/2009 09:30 first > procedure > > john smith 20/11/2009 10:30 > second procedure > > john smith 28/12/2009 10:30 third > procedure > > > Many thanks in advance |