Grouping/Sort question

  • Thread starter Thread starter DEVOURU
  • Start date Start date
D

DEVOURU

I have a list of part numbers with a complete date. I would like to have the
part list sorted by date and duplicate parts grouped. The issue I'm running
into is if I have the same part number with a date at the begiing of the
month, and at the end of the month, the duplicate parts are listed both
times. I am trying to get the group of parts to print on the earliest date
only. Ideas? TIA!

-JS
 
It would make all the difference if you would take the time to enter about
ten records and then how you would like them to display in your report.
 
JS,

Create a totals query with part#, part#, date and primary
key.
Group on part #, count part# and minimum date (I use
minimum rather than first because first isn't always what
you expect).

Add this to your record souce query and join using primary
key.

Your record set should now (hopefully) reflect what you
want.

HTH,

Terry
 
Thankx for the reply. I'm working it.

-JS

Terry said:
JS,

Create a totals query with part#, part#, date and primary
key.
Group on part #, count part# and minimum date (I use
minimum rather than first because first isn't always what
you expect).

Add this to your record souce query and join using primary
key.

Your record set should now (hopefully) reflect what you
want.

HTH,

Terry
Click to expand...
 
Back
Top