mare
Registered User.
- Local time
- Today, 09:59
- Joined
- Jan 20, 2003
- Messages
- 16
I have a database that captures all the documents we create for training purposes. I've created queries so that reports can be run off by business channels (and it's all nice and neat on a switchboard - click the business channel you want, and there's the report of all documents for that channel).
Now, here's the situation: I want to be able to generate a report based on a search criteria, i.e., "coaching", and that a report would come up with everything we have on coaching. I want to include a wildcard so that all titles with "coach", "coaching", "coaches", etc., would appear.
I wouldn't mind if I had to create a "search for" button on the switchboard (which would bring up a "parameter" value box in which you would type in your search) and up pops a report (which I would also create if necessary), but how would I create this query (or is it a filter?). I do have in one of my tables a field for the title of the document (TitleofDocument)
I don't mind the amount of work I would have to do on this -- the bottom line is that it is very user-friendly to others (they actually tremble at the thought of using Access!)
All suggestions would be very much appreciated.
Now, here's the situation: I want to be able to generate a report based on a search criteria, i.e., "coaching", and that a report would come up with everything we have on coaching. I want to include a wildcard so that all titles with "coach", "coaching", "coaches", etc., would appear.
I wouldn't mind if I had to create a "search for" button on the switchboard (which would bring up a "parameter" value box in which you would type in your search) and up pops a report (which I would also create if necessary), but how would I create this query (or is it a filter?). I do have in one of my tables a field for the title of the document (TitleofDocument)
I don't mind the amount of work I would have to do on this -- the bottom line is that it is very user-friendly to others (they actually tremble at the thought of using Access!)
All suggestions would be very much appreciated.