| re: Looking up redundant occurences
As you have not, exactly, defined what you mean by "a certain note", I doubt
anyone can tell you in detail. One way that can be done is to enter the
Social Security Number and display a list of Notes in either Ascending or
Descending order by Date, from which the user can pick one.
The _specific_ date in your example could also be retrieved if you either
specified or had a rule that you were going to retrieve the most recent note
for the person identified by the SSN.
Larry Linson
Microsoft Access MVP
"Ryker" <rasmith@choctaw.org> wrote in message
news:1142011802.479396.304410@e56g2000cwe.googlegr oups.com...[color=blue]
>I have a progress note table where a person's social is entered, the
> current date and then the note. I can have serveral notes entered
> under the same date and I can have several notes entered on the same
> social. My question, how do I lookup and display a certain note based
> on the social and date of the note?
>
> 03/09/06 999-99-9999 Note
> 03/09/06 222-22-2222 Note
> 03/10/06 222-22-2222 Note
> 03/10/06 999-99-9999 Note
>
> If I base the lookup on Date, it pulls the first occurence of the date.
> If I base it on social, it does the same. How would I display the
> note of 03/10/06 for 99-99-9999?
>
> Thanks!
>[/color]
| 
