Accessing Supproting records in a qvd

[#1]

Hi All;

I am trying to work with a qvd to find the number of Days between the two dates.  However, the first date is the DateOpened on the first record.  The CaseAssignmentDate date is on the next record (along with the Assignee and PrimaryAssignee and their names).  Is there a way to have the "master" record (first record) and see all other records that match the CaseID.  My example shows CaseID # 33 & 34.  I need to compute the number of days between 2010-01-20 (CaseAssignmentDate) and 2010-01-11 (DateOpened).

Any ideas out there?

Thanks!

Mike

[#2 · Accepted solution]

Lets call the table you have Case.

Case:

Load * From Case.qvd;

[# of Days table]:

Load CaseID, End-Start as [# of Days];

Load Distinct CaseID, Min(DateOpened) as Start, Min(CaseAssignmentDate) as End

Resident Case

Group By CaseID;

[#3]

Thank you so much!  A little adjustment and it works!