Stumped!

[Stephen Hartman]

Hi all.

I would like to develop a "report" that allows user input based on either
multiple tables or a query. This report would be five columns wide and
allow the user to select different variables for each column from a pull
down list, however based on what was chosen in the preceding column, this
would limit the next pull down list to ony those criteria that matched the
preceding column. I can't recall the best way to accomplish this. Any help
would be greatly apprecited!

TIA

 

[Guest]

Hi Stephen

Not sure what you mean by "develop" a report. So I assum you mean that you
want to allow a user to specify criteria on a form and from that you would
produce a report. ??

If so.

1st I would create a query that pulls all the information that you need from
various tables and in this you can add any calculations (or there could be
done on the report or form - but I prefer to do these in the base query when
possible).

Next create a continous form (as you say "columns") that would allow users
to "select different variables". It may be an idea to use a serise of combo
boxes with the each gaining it's "filter" from the proceeding combo. You can
use the after update event of the combo to filter the available data in the
next. (Called a casscading Combo)

After you have all the data you need there are a few methods you can use to
produce the report with the criteria on the form. You can search on these on
the access help option (F1)

Check out this link
http://support.microsoft.com/kb/289670/en-us

Hope this helps



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.