If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I perform an overall search of all table information
I would like have a control button to perform a comprehensive search for
names, dates, number, etc. I am able to search specific queries based on matching 'names' or 'dates', but I would like to have a search available similar to a yahoo, where you can input anything and results nearing the search are returned. Is this possible? I am using Access 2002 |
#2
|
|||
|
|||
On Wed, 15 Dec 2004 09:11:06 -0800, Rhino5ice
wrote: I would like have a control button to perform a comprehensive search for names, dates, number, etc. I am able to search specific queries based on matching 'names' or 'dates', but I would like to have a search available similar to a yahoo, where you can input anything and results nearing the search are returned. Is this possible? I am using Access 2002 This isn't at all easy - and, in a properly normalized database, should not be necessary. The "Grandmother's Pantry Principle" of "a place - ONE place! - for everything, everything in its place" would suggest that if you're searching for a particular piece of information, there should be only one place (or at the most a very few) to look. For example, consider dates: it would generally make very little sense to do a global search of all the date/time fields in a database for #11/25/2001#. You might find a birthdate, six purchase dates, a table-creation date, 384 record-updated dates, ... Could you explain the nature of the data you are searching, and why you feel this capability is needed? John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Accessing database information when the table has no entries | mike | General Discussion | 2 | October 15th, 2004 04:17 PM |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
Update Existing Table with New Information | Casa | General Discussion | 6 | June 10th, 2004 08:09 PM |