Obtaining information w/o a query

[dbby3]

Hello. I am a new here and have found this resource to be vastly informative.
Much thanks to everyone. With that said, I am struggling with the following
issue:

Currently, the only way I know how to retrieve information from my database
is by writing a query or using a filter. Writing a query is time consuming
and not fit for outside users. Using filters may be right for me but the
output is not in the format I want. Here is why:

The table that I am filtering is large, many subforms. I can filter by form
very nicely to find particular records, but the entire record is displayed. I
would like an output in tabular form only showing those elements that have
been searched for in addition to whatever elements the user chooses to show.
I would also like the user to have the ability to maintain the use of basic
functions in their search. For instance, display companies only with
employees greater than 100,000. Basically I want the ease of the filter to
accomplish the task of a query (with a form output). It would be nice to
automatically force the output of a filter into a form "template."

I have begun looking at data access pages as a possible solution. Will this
provide me with the capabilities I am looking for? Perhaps the better
question is, can anything provide the capabilities I am looking for? The
ideal solution would be an easy information recovery tool that someone with
no knowledge of Access can use.

Thank you for any assistance you can provide.

 

[Golfinray]

My opinion is that it is much easier to do what you want with a query. In the
query criteria you can put any number of thigs, like >100,000 if you only
want those, dates like Between 1/1/2007 and 1/1/2008 or many others. Check on
query criteria in the help files and see if you find some might be able to
work with.