PC Review

Thread Tools Rate Thread

Re: Keyword search across multiple tables

Lars Brownies
Posts: n/a
      9th Jan 2010

To search across multiple tables you can use a union query which can be
incorporated in Allen Browne's solution Gina mentioned. A union query
consists of multiple queries of which the order of the fields as well as the
number of fields must be identical. For more info see:


"TJEngel via AccessMonster.com" <u57354@uwe> schreef in bericht
> Hi everybody,
> I am an Access newbie. I THINK this can be done.
> I would like to have a search box on a form where a user can enter text
> and
> click a "Search" button. Clicking the search button will a) run a
> multiple
> table query (on a single field in each table) and b) display the results
> of
> this query in a report for the user to view. I basically need to conduct
> a
> multi-table query with the criteria equal to the text that the user enters
> in
> the text box, and display the results in a report.
> Is this do-able? Or am I delusional?
> Thanks, Monsters!
> TJ
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...oding/201001/1

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Keyword search across multiple tables John W. Vinson Microsoft Access Form Coding 5 10th Jan 2010 08:40 PM
Re: Keyword search across multiple tables Gina Whipp Microsoft Access Form Coding 0 9th Jan 2010 04:30 PM
Can we use join keyword without using INNER keyword explicitly in. =?Utf-8?B?Uy5TUklLQU5USCxHVURJV0FEQSxBUCxJTkRJQQ== Microsoft Access Queries 1 20th Apr 2005 02:07 PM
Difference between C#'s "new" keyword and VB.NET's "shadows" keyword Dot net work Microsoft C# .NET 8 29th Aug 2004 11:00 AM
Provider keyword in connection string not a valid keyword J. Muenchbourg Microsoft Dot NET 1 18th Mar 2004 10:50 PM




All times are GMT +1. The time now is 11:25 AM.