I created a query that sorts part numbers by company (in ascending order), then component number (also in ascending order), status = active. And it looks great.
My boss wants me to create a report off of this where we can list them, then send the information to each manufacturer (of course separately) so they can verify any obsolescence components for the coming year.
I've create a report and it sorts by component, then company, which is not what I want. Here's the screen shots:
Query Set up:
Query view:
Report setup
Report results:
The following pages list the rest of the IC components, then the QF components, etc.
Also, I'm not able to force printing onto a new page for each company.
Thank you, Rebecca