Access delima

[Craig]

I am setting up a database for a manufacture of tape
drives. The employees will enter data pertaining to test
results at each phase of the product development phase. I
want to be able to enter a product serial number and see
all the tests results each employee entered. Is this
possible? And if so, how do create a query in order to
access this information.

Craig

 

[Elwin]

It sounds like you want an open parameter query.

1) Create your query.
2) On the criteria row of your Serial Number field place
any parameter you like, but surround it with brackets.

eg) [Please enter serial number]

When your query runs it will prompt you to provide that
information and use the value to filter the records it
returns. Not a very elegant solution, but it accomplishes
what you've described.