Form to Select/Create a Report

L

Lloyd

I think the only way I will be able to get users to really use this database
is if I can provide them with very flexible reporting. I would like to
create a form that gives the user choices about what information they see in
a report. Following is a brief decsription of what I would like to do. But
I need help in thinking through and implementing my idea. Can someone point
me to an example of such a system? Or is this too complex for someone with
limited Access97 experience?

Form for Reports
Records – what records do you want to see? List of fields – user can
specify values in those fields?

Display – What information do you want displayed? Several formats with
radio buttons to chose one (I have an options box defined for this piece with
a label showing the general layout of each option.)

Sort – What order do you want to see the records in? Fields listed with the
ability to specify first, second and third order.

Group/Report Footer – What kind of summary or grouped information do you want?

Button to create the desired report.

Thanks for any help you can provide,

Lloyd
 
Top