How do I filter within a group?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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
Click to expand...
number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group header makes report too long 4
VBA: How can I use a string variable as autofilter criteria? 4
Counting Unique Values within a Group 2
Filtering subreports on main report 0
Count In Group Footer 1
How to filter data in a subreport 4
Filtering part of a report 7
grouping based on checkboxes 1

Back
Top