473,396 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Combining results from multiple yes/no fields in query

Hi everyone and thanks for your help in advance :)

I have a problem with a query where I want to get data from more than one yes/no field.

All the yes/no fields are in the same table and each record in that table can be either A, B, C or D
This category is determined by at yes/no field

In theory a record can be more than one letter but this has not happened yet.

In my query I want to be able to get a single letter or a combination of them.
Fx Query: A and B yes - Result: A and B and AB

In a previous database I used this code as criterua to get the result but oddly enough this does not work in the new database :S

Column: FindA (Refers to Yes/No field for A)
Criteria: Like IIf([Forms]![FormSearch].[FindA]=True, [Forms]![FormSearch].[FindA], "*")

Column: FindB (Refers to Yes/No field for B)
Criteria: Like IIf([Forms]![FormSearch].[FindB]=True, [Forms]![FormSearch].[FindB], "*")

and so on...

Right now the only return for a search for A and B is AB. Not all A's without B and B's without A. And I really want those too :)
Oct 31 '16 #1
2 2255
jforbes
1,107 Expert 1GB
You have me a little confused on what you have attempted. Could you switch to SQL view for the Query, then copy and paste the SQL here?

My guess is that you are ANDing your criteria together instead of ORing it.
Nov 3 '16 #2
You are absolutely right. I am AND'ing it in my query builder.

Thanks for the head up :) And the help :)
My brain must have turned to sludge :S
Nov 4 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Richard Coutts | last post by:
I have a query created by the "Find Unmatched" query that lists items in a table that were not selected by another query. The Query does what it needs to do, but I can't edit any of the resulting...
2
by: PPT33R | last post by:
The MS Access website is very unhelpful on this topic, and I cannot find anything in my Googling to find a hint. I am working with very large, existing data sets that consist of multiple fields....
3
by: tesc | last post by:
I am so aggravated and need any help I can get. I am using Access 2000 and am trying to sort multiple fields in a select query. My query is set up as follows: FIELD 1 FIELD 2 FIELD 3 ...
3
by: JIM.H. | last post by:
Hello, I am suing SELECT * from MyTable in a stored procedure and populate dropdown list. By using followings: ddlSP.DataSource = DS; ddlSP.DataTextField = "PName"; ddlSP.DataValueField = "PID";...
3
by: mkjets | last post by:
I have worked for hours on trying to find a solution and have not figured it out. I am working in Access 2003. I need to create a query that takes values from 1 table and displays them in...
11
by: nsymiakakis | last post by:
Hello everyone, I know Access fairly well, but I am very, very weak on SQL. I have a very large table that I need to pull a grand Total from multiple fields. I have created a query to SUM all the...
2
by: Nathan Sokalski | last post by:
I have a Repeater that uses a DataSource that has multiple fields. When the values of these fields is displayed in the Repeater, there are fields that are used in combination with other fields as...
482
by: bonneylake | last post by:
Hey Everyone, Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place. ...
27
by: mindbenderz | last post by:
I have a form (frm_docs_lookup_list) with 3 field controls: equip_sr, po_sr, vend_sr the form has a subform attached to : subfrm_docs_lookup_list the results in the subform display based on...
1
by: sc5502 | last post by:
Front End: MS Access 2010 Back End: SQL Server 2008 My skill set 1-10: Access 5, Sql 4 I have a form (unbound) that has 3 fields to be input, date, line and shift. The user fills in the fields...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.