I want to collect multiple data items using a form to make a repor

[Dean]

Goal: Create a report that may contain one of many items that are in stock.
This information needs to include all informaiton about the items in stock.

I have data in an Access Data that was collected using Excel. I used Access
to create an Access Table. From the Access Table I created a Access Query.

I would like to create a form that will allow the user to view a report that
lists all the items in stock matching a befrief search criteria. Information
of items in stock may have other charactristics that are not an match but are
not relevent to the charactristics requested in the search. However all data
about the returned matches need to displayed to make the best possible
selection.

What articles should I be reviewing to accomplish this tasks.

 

[BruceM]

I think a tutorial that covers the basics of database design would be a good
place to get started. There is one such here:
http://allenbrowne.com/casu-22.html

If you use the query to limit the records to ones that contain a particular
value or range of values in a field, the rest of the values in the record
will appear. Your description is vague, but if you have, say, a Category
field in a hardware listing, and you want to see everything in the
Electrical category, set the criteria for Category to Electrical (using a
value that actually appears in the field). Or as the criteria:
[Enter Category]
This will prompt the user to enter a category.