473,657 Members | 2,380 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How To Show All Other Records When Using A Critieria In Query Design?

91 New Member
Hello,

I will give a simple example. I have a table [RuleMap]. It has a field called [Rulename] and[Ruletype]. [Ruletype] has entries like Handbook, Guidance and Legislation. Some of the records do not have the [Ruletype] mentioned against [Rulename].

I have designed a query in the Query design view. I do not want to see the [Rulename] where [Ruletype] is Legislation. I have used "<> Legislation" in the criteris for [Ruletype].

The query is working fine but it is not showing the records [Rulename] where the [Ruletype] is blank.

How do I show all records even where the [Ruletype] is blank?

Please advise.

Thanks.
SG.
Apr 27 '12 #1
3 1280
sg2808
91 New Member
Got it... I added "Is Null" in the Or field below.
Apr 27 '12 #2
roshan ban
21 New Member
Try This Code
Expand|Select|Wrap|Line Numbers
  1. Select *
  2. From RuleMap
  3. Where RuleType Not in ('Legislation')
Apr 29 '12 #3
NeoPa
32,568 Recognized Expert Moderator MVP
A clever idea, but unfortunately it doesn't work.

It would be a good idea to indicate, when posting, that you are guessing and haven't actually tested your suggestions. Members generally assume a suggestion has either been tested specifically, or is posted by someone who has a fair set of experience in the subject. If neither of these is true then it's only fair to indicate that in your posts.
Apr 29 '12 #4

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

Similar topics

5
3513
by: Jimmy Tran | last post by:
Hello, I am doing a bmw tracking project for school using asp and access2000. on my search.asp page, I can search for a particular bmw and order it if i want. It works fine when i do select query to get data. But when I try to order a bmw(using update query), it gives me this message error: Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /bmw/search.asp, line 257
1
1665
by: Jakob | last post by:
Hey... Why do I sometimes experience low performance when I use a parameter instead of an exact value? For example the following performs very bad:
16
1753
by: William Buchanan | last post by:
Hi folks I want to show 2 records on a page side by side. Each record has an image which will be displayed and a bit of text. How can I do this? Thanks Will
10
6721
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that contains only tables. I have linked the tables for the front end to the back end database. I am trying to set the recordsource of a form to a query established by the user to narrow the scope but I don't want to display the form if there are no...
2
8076
by: Zeljko | last post by:
I'm creating Address book. Header of the main form (frmAddress) contains combo box (cboFilter) to filter records by Occupation on main Form(Ocupation1). That's working. Combo box also have "Show All" in one row. ==Combo box query: SELECT tblOCUPATION.id, tblOCUPATION.txtOcupation1 FROM tblOCUPATION UNION Select "(All)" as Bogus, Null as AllChoice From ; ==Combo box event: If IsNull(Me!) Then
3
2230
accessbunnie
by: accessbunnie | last post by:
Hello Access Users! I am a bit of an Access novice and am currently creating a database and have come up against a huge (for me!) road block. I do not write in Access code and instead, tend to just use design view and wizards to create my databases. I created a form using a query I created composed of two different tables with the same unique identifier. All things went fine while I dragged my variables from the field list to the...
6
2182
by: ringer | last post by:
I need to run an append query when I open my db that will look at a date in the records and copy the records when date() >= and some other criteria. I have the append query working perfectly. But the records still need to have some code run on them to set up fields in the new records that should not be copied from the old records. It is mostly math and date manipulation using values in some fields to compute with and write the results to...
2
1798
by: Torben Laursen | last post by:
I use the component WebBrowser on a form. Each time I open the form with the component inside VS2005 I get this error: "Windows Internet Explorer Cannot find ....:/Users/Torben/AppData/Local/Microsoft/VisualStudio/8.0/ProjectAssemblies/f9gu89ax01... Make sure the path or internet address is correct" The error is only inside VS2005, the appliation runs fine.
1
2361
by: prathna | last post by:
Hi .. I have a logic:iterate tag which will display 5 rows each row with a drop downlist and 2 textfields.now by default all the rows will be shown.how do i hide all the rows except the first one.i know how to show/hide a row when its not dynamic.but i dont know how to do it when its logic iterate tag. <logic:iterate indexId="index" id="phoneItem" name="nameForm" property="results"> <% String dropdownType = "results.dropdownType";...
2
9834
by: existential.philosophy | last post by:
This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design view. That same query takes about 20 minutes to open in datasheet view. As an experiment, I deleted all rows in all tables; after that, the query took only seconds to open in both design view and datasheet view. From these facts, I conclude that Access is evaluating the query when I go to...
0
8825
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8732
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
8605
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
6164
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
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4152
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
4304
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1955
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1615
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.