If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to collect multiple data items using a form to make a repor
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. |
#2
|
|||
|
|||
I want to collect multiple data items using a form to make a repor
I think a tutorial that covers the basics of database design would be a good
place to get started. There is one such he 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. "Dean" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|