473,670 Members | 2,393 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Multiple Field Search

itm
My boss has an Access 2002 db with 2 tables that each include almost
1,000,000 records. Their common demoninator is an account number. One
of the tables has 10 column fields with jurisdiction numbers. He wants
to search all 10 column fields with the result being all records and
their associated information for a specific jurisdiction number. The
jurisdiction number for an account would not be duplicated in a column
field but could be located in any one of the column fields so each
column field has to be searched for each account number until that
specific jurisdiction number is located (if it is-many of the accounts
won't even be located in the jurisdiction selected).

Now I am not an experienced sql, vba, or function writer so I consider
this completely over my head so your detailed help would be very much
appreciated!!!! !!!!!!! THANKS! Mary Ann

Nov 13 '05 #1
1 1708
it*@itmservices .com wrote:
My boss has an Access 2002 db with 2 tables that each include almost
1,000,000 records. Their common demoninator is an account number.
One of the tables has 10 column fields with jurisdiction numbers. He
wants to search all 10 column fields with the result being all
records and their associated information for a specific jurisdiction
number. The jurisdiction number for an account would not be
duplicated in a column field but could be located in any one of the
column fields so each column field has to be searched for each
account number until that specific jurisdiction number is located (if
it is-many of the accounts won't even be located in the jurisdiction
selected).

Now I am not an experienced sql, vba, or function writer so I consider
this completely over my head so your detailed help would be very much
appreciated!!!! !!!!!!! THANKS! Mary Ann


In the query builder you put a criteria entry under each on the 10 columns
making sure that each criteria is on its own row. This produces an "OR" of
the criteria rather then an "AND". The resulting SQL is similar to...

SELECT * FROM SomeTable
WHERE Field1 = SomeValue
OR Field2 = SomeValue
OR Field3 = SomeValue
etc...

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
8767
by: TH | last post by:
I am (still :) working on a recipe database. Now I am trying to figure out how to set it up for an ingredient search. What I want it to be able to do is three things: 1. Search based on just one ingredient 2 Search based on two ingredients so that the recipe would have to have both ingredients to show up in the results 3. Search based on three ingredients so that the recipe would have to have all three ingredients to show up...
8
579
by: TJS | last post by:
what are folks doing to get around limitation of one server form per page ?
5
4176
by: JP SIngh | last post by:
Hi All This is a complicated one, not for the faint hearted :) :) :) Please help if you can how to achieve this search. We have a freetext search entry box to allow users to search the database. I am searching two tables. SELECT TapeRecords.Id, TapeRecords.ItemTitle, TapeRecords.SourceRef,
4
3558
by: RoadRunner | last post by:
Hi, I have a question. I am asked to produce a global search of a given corporate name, in more that one database. Each database has different table names and different field names in the tables. Does anyone know if this can be done? Thanks
3
2837
by: tdemartino | last post by:
I've been searching for days, using MS help and I can't find the answer on my own. I have this code in my Access Form: If Not IsNull(Me.txtFilterDescriptionMatName) Then txtFilterDescriptionMatName = Replace(txtFilterDescriptionMatName, Chr$(34), Chr$(34) & Chr$(34)) StrWhere = StrWhere & "( LIKE ""*" & Me.txtFilterDescriptionMatName & "*"" ) AND "
4
5036
by: Dan | last post by:
Hi all, I am creating a search table where the keywords field is made up of several text fields and this is causing me some problems. I can concatentate the text ok but i can't seem to concatenate matching records here is the cursor loop. I'm not a fan of cursors but also didn't see another way of achieving this. declare @ptr1 varbinary(16) declare @Ptr2 varbinary(16) declare @profileid int declare @x int
1
8219
by: trpost | last post by:
How can I accomplish the following using AJAX / PHP: I have a form with a text field and a search button next to the text field. When I type something in the text field and hit the search button a query is performed and the results are dynamically entered into a multiple select box below the textfield without reloading the page, or affecting other form elements. If no data is found then an error message is displayed in place of the...
1
3371
by: assgar | last post by:
Hi I was using a schroll bar to display multiple rows of dynamically created from database records. The scrolling was not displaying the data properly so I have decided to use pagination. The problem I am having is, if I select one item on page #1 and another on page #5 only the last item selected on page #5 is stored in the array. How can I store selections from multiple pages into one array?
5
11957
by: mforema | last post by:
Hi Everyone, I want to search records by typing in multiple keywords. I currently have a search form. It has a combo box, text box, Search command button, and a subform. The combo box lists the names of the fields found in my subform. The search form is supposed to allow a user to choose which field he/she wants to search by and then type a keyword(s) in the text box. The subform should display the filtered results. My problem occurs...
1
1997
by: Kye | last post by:
It has been a while since using vb an now I have started a project and I am not sure where my mistake is in my code. Basically what I am doing is trying to build a multiple search string with certain criteria being asked, the criteria is in 4 separate fields with a search where I am able to enter multiple information, or just search a single field . Now it works to a certain extent but when trying to enter a double field for model and colour...
0
8471
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8817
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8663
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6218
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4215
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4396
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2804
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2046
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1799
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.