How to use dropdown lists to run a query in a Data Access Page

G

Gaby

I'm trying to set up a DAP (it will be used through an HTML based interface
NOT connected to a network - it's all self contained in the user's computer)
that will run a query and display the result. The user does not input any new
data into the database. The way it works is:

There are four drop down lists with set choices (the user will never have
the choice to input data during the entire process). Once the user selects
the four choices, a query is run which will do a number of calculations and
will display, at the bottom of the same page, an assessment based on the
numerical value of the calculation.

I have all the tables and queries done. I tested them through the tables and
they work. What I don't know how to do is:
- How do I insert a button that the user can click on to execute the query?
- How do I make the report to show up at the bottom of the same page?

I would really appreciate any help with this as I'm REALLY pressed with time
(I have to have this working in the next 24 hours!)

Thanks!!!!!
 
Top