Query Filtering

[square]

I have a table that stores different visits to clients and the key fields in this table are the ClientName and VisitDate.

I am trying to design a query that extracts from the above table only the latest visit to each client where there is more than one visit found and if there is only one in the entire table, just that one.

I would appreciate any assistance.

Square

 

[john471]

Your problem would seem to be the same in nature as the one in this thread, except that poster calls "ClientName" "Hole Number" and "VisitDate" "Hole Depth".

Check out Pat Hartman's reply in that thread (and ignore mine )....

should point you in the right direction.

 

[square]

john471,

Thank you very much for your guidance and the other members who contibuted in the link you provided - invaluable!!

Square.