K
ko5500
I have a table containing data regarding patients' visits to medica
offices. Here is a sample:
Patientnumber patientname dateofvisit
001 Joe 1/15/04
001 Joe 2/21/05
001 Joe 2/11/06
001 Joe 3/1/07
002 Jane 1/2/04
002 Jane 1/13/05
002 Jane 1/16/06
002 Jane 1/3/07
I want to create a query that will add a field showing the date of th
last visit for each record. It should look like this:
Patientnumber patientname dateofvisit lastvisitdate
001 Joe 1/15/04
001 Joe 2/21/05 1/15/04
001 Joe 2/11/06 2/21/05
001 Joe 3/1/07 2/11/06
002 Jane 1/2/04
002 Jane 1/13/05 1/2/04
002 Jane 1/16/06 1/13/05
002 Jane 1/3/07 1/16/06
Any help would be greatly appreciated. Thanks in advance
offices. Here is a sample:
Patientnumber patientname dateofvisit
001 Joe 1/15/04
001 Joe 2/21/05
001 Joe 2/11/06
001 Joe 3/1/07
002 Jane 1/2/04
002 Jane 1/13/05
002 Jane 1/16/06
002 Jane 1/3/07
I want to create a query that will add a field showing the date of th
last visit for each record. It should look like this:
Patientnumber patientname dateofvisit lastvisitdate
001 Joe 1/15/04
001 Joe 2/21/05 1/15/04
001 Joe 2/11/06 2/21/05
001 Joe 3/1/07 2/11/06
002 Jane 1/2/04
002 Jane 1/13/05 1/2/04
002 Jane 1/16/06 1/13/05
002 Jane 1/3/07 1/16/06
Any help would be greatly appreciated. Thanks in advance