Querry Sharing

[Colleen]

I have created a query. I need to send them
the "template" for this query so they don't have to
create all the expresions. They are very computer
illiterate so there is no way to talk them through this
big query.
Is there anyway to do this.
any help would be appreciated

 

[John Vinson]

I have created a query. I need to send them
the "template" for this query so they don't have to
create all the expresions. They are very computer
illiterate so there is no way to talk them through this
big query.
Is there anyway to do this.
any help would be appreciated

A Parameter Query might be the ticket here. Instead of a literal
string as a criterion, put

[Enter search term:]

on the Criteria line. When the user runs the query (or, better, opens
a Form or a Report based on the query by clicking a switchboard
button), they'll be prompted with whatever is in the brackets, and the
query will search for and display all records which match that
criterion.