|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2004, 06:51 PM
|
|||
|
|||
How do I filter within a group?
I am using Access 2003 and would like to filter records within a group. I
have a series of part numbers that may have a new record added daily. I want to run a report that lists only the most recent record for each part number. 
|
|
#2
October 5th, 2004, 03:41 AM
|
|||
|
|||
|
How would you identify the most recent record for each part number? Do you
have some sample records with table and field names? Could you show us how you would expect them to appear in a report? -- Duane Hookom MS Access MVP "wendell00lg" wrote in message ... I am using Access 2003 and would like to filter records within a group. I have a series of part numbers that may have a new record added daily. I want to run a report that lists only the most recent record for each part number.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Requery Subreport For Each Group | Melissa | New Users | 0 | September 30th, 2004 07:26 AM |
| Sending Email To A Group | Ron Sommer | Outlook Express | 4 | August 28th, 2004 03:33 AM |
| Filter - Advanced Filter? | carrera | New Users | 4 | August 13th, 2004 09:33 PM |
| Group By | Running & Setting Up Queries | 3 | August 5th, 2004 10:37 PM | |
| change Group name | Sasan | Setting Up & Running Reports | 3 | June 29th, 2004 08:10 PM |
Linear Mode
