M
Mikey C
Hi Guys
I need to be able to action a number of queries (& also reports) on my
database. Currently I have a large number of queries / reports ready
made so users can just choose the way they want the data sorted.
Obviously it would be impossible to include a query / report for every
possible situation. Many of these queries / reports have been set-up as
parameter queries to automatically filter the results. Additionally I
have included pivot tables which are a great way to sort the financial
data.
Finally! - My question is ...
Is there any way that I could build some kind of form where users could
choose the specific parameters they require to create custom queries /
reports (Using combo boxes)? At the moment, users have to amend
standard queries in design view (most do not know how & is not
particularly user friendly!).
Please be gentle (I'm not an access pro!!)
Appreciate any help you can give
I need to be able to action a number of queries (& also reports) on my
database. Currently I have a large number of queries / reports ready
made so users can just choose the way they want the data sorted.
Obviously it would be impossible to include a query / report for every
possible situation. Many of these queries / reports have been set-up as
parameter queries to automatically filter the results. Additionally I
have included pivot tables which are a great way to sort the financial
data.
Finally! - My question is ...
Is there any way that I could build some kind of form where users could
choose the specific parameters they require to create custom queries /
reports (Using combo boxes)? At the moment, users have to amend
standard queries in design view (most do not know how & is not
particularly user friendly!).
Please be gentle (I'm not an access pro!!)
Appreciate any help you can give