User Friendly Query

[bowks14]

Hi all, I have a simple question. I have made a database that tracks deposits and also has several fields pertaining to these deposits (company, date, etc.) I need all of these fields to be searchable, sometimes even searching on a combination of fields. Obviously this is easily done in Access under the Query Design View under criteria, sort, etc. However, a non technical person will be doing the searches and we do not want to have to train her on how to use Access.

Is there an easier way, perhaps by making a form, to allow all fields to be searched and then results displayed?

Thank you!

 

[Brianwarnock]

Yes this is possible , of course you need to allow for some fields to be null. Have you looked at gfilter by form, I taught non techies to use that to search by whatever they wanted to pull info from an archive DB.

Brian

 

[bowks14]

How do you do filter by form?

 

[Brianwarnock]

You type filter into Access help and then search and then read apply a filter.

 

[bowks14]

Ok, I have the Filter by Form working. But now I want the recordset produced from the filter to be placed in a report to be easily printed out. Is this possible?

 

[Brianwarnock]

I don't know how you would put it into a report but you could just print the forms. If that goes not satisfy your requiremyrs then you will need to design a form to use as input parameters to a query on which the report is based.

Brian