Happy New Year and HELP!!! I have a report based on a query that
displays all of the visit dates of patients serviced by a clinic. In
a report, I need Access to display the first - or least recent - visit
per patient for each patient. E.g., I select ClinicA on a form. My
report then displays Mr Jones, Ms. Smith and all of the dates that Mr.
Jones has been to ClinicA and all of the dates Ms. Smith has been to
ClinicA.
I need my report (or query - which ever is easiest) to list only the
very first visit date from a long list of visit dates PER PATIENT
NAME. Do I use the DFirst function? If so, how? All of the help I
have viewed so far re:DFirst have been vague, especially in describing
the "domain." Thank you!
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
