The jobs are identified by a unique job number (which is a field). I know
about queries, but I have not created them myself.
1. Make a new query in design view
2. Add your table
3. In the designer, drag the star from your table onto the grid.
4. Drag your unique job number field onto the next column in the grid.
5. uncheck the checkbox below the job number in the grid
6. in the column under the job number field, on the row that says
"Criteria", type something like this:
IN (a, b, c, d....)
Where a, b, c, d, etc are your 25 unique job numbers separated by commas.
If the job number field is a text field, then the job numbers you type will
need quotes:
IN ("a", "b", "c", "d", etc...)
7. You switch to "Datasheet View" to see the records it gets.
8. Don't forget to save your query.
9. Get yourself a copy of "Access xxx Developer's Handbook" by Sybex, where
xxx is your version.
10. Learn about "Parameter Queries" either from here, or that book, or
Access help. The nature of your question suggests that you will be doing
variations on this query, so it's nice to have one that's reusable for
different input values.
--
Peace & happy computing,
Mike Labosh, MCSD
Feed the children!
Save the whales!
Free the mallocs!
