I'm a database marketing manager for a small non-profit. I created a
query that prompts you for a company name and then pulls a list of all
of our contacts in the database in that company. Our sales folks are
always asking for company contact lists and I just plug it in to this
query and send them the list in excel.
I want to give them the capability of using this query themselves
without going through me. But I want them to do this without having to
open up Access, shuffle through all the tables and queries that make up
this query to find this query and then running it. Ideally I would
love to have a shortcut in one of our network drives that they click on
and it automatically prompts them for the company name.
Do you know the best way to do this? Any advice appreciated.
Thanks!