Can Access do this?

[Corey J]

I am getting dizzy from going 'round & 'round with this.
Perhaps someone taking a fresh look from the outside can
see it more clearly...???

I have numerous individuals who are not familiar with
Access and have varying data needs (way too many to write
a query for each possible scenerio)who need to retrieve
information from a particular database.

I am wanting SOMETHING (query? form? report?) that looks
like a form, acts like a versatile query, and produces a
report.

Can Access even produce such a thing? IMPORTANT: Those
who utilize this tool must not be able to modify the
database.

 

[Tim Ferguson]

I am wanting SOMETHING (query? form? report?) that looks
like a form, acts like a versatile query, and produces a
report.

Microsoft Query? It's installed with every version of Office. Even an
average user can be taught how to create queries inside an afternoon.

HTH


Tim F

 

[Cathy]

There is another possible answer to your problem. Take a
look at http://www.mvps.org/access/forms/frm0045.htm and
download the appropriate database. Inside you will find a
form with instructions that will list all of your tables
and walk the user through creating their own sql.

Cathy

 

[Guest]

Thanks Tim, but I don't think you understood my
question. (And you meant "Microsoft Access"
not "Microsoft Query," right?)

I know one can write queries within Access, HOWEVER

I am wanting to create a single tool, in form format,
that will in essence feed the criteria into a query
without the user needing to know a thing about writing or
editing a query. (Please see original question.)

CJ

 

[Larry]

Access is perfect for this.

You could design a form for the users to enter in search
criteria specific to their needs. This criteria can then
be fed into a query that would retrieve the appropriate
info from the database. It can then be displayed as a
report.

Obviously, you would need some programming ability to do
this.

Thanks,
Larry

 

[Tim Ferguson]

Thanks Tim, but I don't think you understood my
question. (And you meant "Microsoft Access"
not "Microsoft Query," right?)

No: I meant Microsoft Query. It's an end user tool for designing and
running database queries as per your original post:

I have numerous individuals who are not familiar with
Access and have varying data needs (way too many to write
a query for each possible scenerio) who need to retrieve
information from a particular database.

B Wishes


Tim F

 

[Pete Sheridan]

Hello Corey J.,

Look up 'Query by form (QBF) in the Microsoft Knowledge
Base! This is a method that will allow you to do exactly
what you are looking for.

Hope this helps,
Pete Sheridan