Restrict query to calculate on last record for each subject 1

[ad2]

Hi,

I have a query which calculates when patient's next 6 month appt is due, based on the date of their last visit.

It is working fine except it calculate and displays all the patient's records, not just their last appointment and the date 6 months out.

How do I restrict the query to run only on the last visit date and calculate the 6 months out?

Current SQL is:

SELECT PatID, VisDate, [VisDate]+180 AS [Next 6 Month Appt Date]
FROM tblExam;

Thanks!

 

[randy700]

How about...

SELECT PatID, Max(VisDate) As LastVisit, LastVisit + 180 As NextVisit FROM tblExam

Randy

 

[PWise]

SELECT PatID, Max(VisDate) As LastVisit, LastVisit + 180 As NextVisit FROM tblExam
group by PatID

 

[ad2]

Thanks Randy700 and pwise, this is most helpful