Find & Summarize

[Mark L]

Attached is a little example of an application I'm working on.

Background: A patient visits the doctor and a battery of tests are run that day. The application produces a file called Patient Test Results. The Patient Test Results file tracks the following:

Patient ID (unique per patient)

Patient Lab Date (date format)

Patient Test ID (unique per test)

Patient Test Result (numeric)

Goal: I need a way to give the user the ability to populate a date field based on a choice of

existing Lab Dates (as found in the Patient Test Results file) for a given Patient ID.

Extra Bonus:

1) Ideally, it would default to the most recent Lab Date.

2) Even more ideally it would warn the user if there are no Lab Dates for this user.

(Note that in the attached example the Date field is currently blank - because I don't know how to populate it yet. But I wanted you to see what needed filling in.)

I'm thinking this will be quick work for a sharp mind - which I confess to not having.

Thanks in Advance,

Mark

Test_Case_No._2.zip

[-Queue-]

See attached for changes. Note that I have changed the file name so that the ValueListItems calculation will work.

TestCaseNo2.zip

[Mark L]

-Queue- what can I say? You continue to amaze me!

You've really taught me the a value of a good Value List (pun intended.)

A Hearty Thanks,

Mark