form needed request

L

lee

i have five different queries which are not linked each other but are
part of a project. I need to create forms which will run these queires
by click of buttons. i need to run queries in different ways- by sum
of sales, by sum of qty etc- Each query has these fields

faciltiy1 query

sales cost totals %


I want the following forms and buttons

Run facility1 query

When a user clicks on the above button, it should prompt for the
following button

by state
by zip code

when the user clicks on one of the above buttons, the form should
display the result by summaring the data within the query. the form
should do the calculation

I need these buttons or fomrs for all the five differnet queries
stored in my database
 
Top