I am trying to create a search form. I have 4 criteria that the user can search on: Activity Name, Org Name, Address & Event Date. I would like to have Access search by any or all of those items, based on what the user types in. For example, the user types in Ward in the OrgName and 4251 in the Address. I would like the results to include any records that Ward and 4251 in the record as well as any that have only Ward or 4251. To throw another request at you. Can I also program the search to search multiple fields for the same keyword? For example, the user types in Ward in the Activity Name search field and records with Ward in the Activity Name or Org Name shows up as the results?
I know that I can do a search by form. If I do that though, the results show up in the form view. I would like the results to display in the worksheet view.
I have no idea even where to begin.
Thanks.
Karen
Posted by: k2j1203@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar