Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database Access 2003 with just 10 fields and three tables and two reports. Now I want to create a third report that will prompt the user to chose from one of the tables which is a drop down box. Based on there selection I want a report to print what they want. I want a report to do the following Example: I have a table named “Items†and there are 50 items listed if the user wants a report on who has Tables and Printers. They should be able to click on the report and a dialog box should come up and prompt them to choose from the “Items†table what they want to see from one item to all and click on ok and a repot list all the records with that item in it.

Please help.
 
Doug

You have used the word "tables" with what seems like more than one meaning.
I'm afraid I don't really have a very good idea of what kind of data you
have stored, in what kind of fields, in what kind of tables.

Before offering suggestions about how to use what you have, to do what you
want (which I am afraid I don't understand very well either), I'd need more
information about your underlying data structure.
 
Back
Top