Records management

Con · September 9th, 2003, 07:51 AM

I have these records:

Name ID SickCode Date
Jane 2345 607 4/2/2002
Jane 2345 607 7/14/2001
Jane 2345 607 7/30/2001
Jane 2345 7011 4/5/2001
Sam 3876 2330 6/7/2003
Sam 3876 457 5/23/2000
Sam 3876 2330 9/12/2003

This is what I want to obtain when I query using Access:

Jane 2345 607 4/2/2002
Jane 2345 7011 4/5/2001
Sam 3876 2330 6/7/2003
Sam 3876 457 5/23/2000

I just need a sample of the sickcode for each name (doesn't matter the dates)

If anyone can help me to query this using Access, I'll really appreciate your assistance. Thank you very much.

John Anthony · September 9th, 2003, 08:22 AM

Ok, pretty simple. Do this.

In the table, set the index of the table to the SickCode field.

Then in your query's properties, set the "Unique Values" field to YES.

This will give you your desired results.

Let me know if you get stuck on it.

John

John

BethMoffitt · September 9th, 2003, 08:25 AM

Highlight your table, click Insert > Query. Click Design to open a new query in design view based on your table. Select all of the fields and drag down to the QBE grid. Then click View > Totals. Under your Date field change 'Group By' to 'Max'. This will give you the max date for the unique entries as you described.

Regards,

Beth M