Topics Search

Null as Character in MS ACCESS 2003 Queries

Null as Character in MS ACCESS 2003 Queries
Views: 2
I have following query

Select * from Table t1
where t1.a Like ("*" & LTRIM(RTRIM([forms]![Search1]![cboInput1])) & "*")

Here when my prompt value is empty I'm getting only "Nokia and HTC" But I wish to get 4 values.

I know in Oracle when I give

Select * from Table t1
where t1.a Like '%%'

This gives all values in Oracle. But why not in MS ACCESS?
Sponsored Links:

Similar posts...

 

How to construct a hierarchy from a list? (Access 2003)

How to construct a hierarchy from a list? (Access 2003) Icon
Using Access 2003, my objective is to turn a list like this:

Asset ID | Parent Asset ID
1 | | NULL
2 | | 1
3 | | 2
4 | | 3
Etc.

Into a table like this:

Asset ID | Parent 1 | Parent 2 | Parent 3 | Etc.
1 | | NULL | | NULL | | NULL | |
2 | | 1 | | NULL | | NULL | |
3 | | 2 | | 1 | | NULL | |
4 | | 3 | | 2 | | 1 | |
 

Microsoft Access 2003 (comprehenisve)

Microsoft Access 2003 (comprehenisve) Icon
A complete tutorial on Access 2003. It includes 12 units which includes reports, forms, action queries, crosstab queries, summary queries, relationships, creating and modification of data tables, and more.
 

multicolumns unique index and null

multicolumns unique index and null Icon
I've MS Access 2003 and three columned unique index. I.e. columns Client, Case and ParentCase. ParentCase could be a null value. Ignore null property is false, but I can insert two identical rows. I.e.
Client, Case and ParentCase
1 1 null
1 1 null
Is it really normal?

How can I force unique records out of Access when one column contains a null value?
 

MS Access 2003 - Returning Not Null Field Entires

MS Access 2003 - Returning Not Null Field Entires Icon
I will admit right up front that I'm far more experienced in SQL Server and Oracle than I am Access,

I have a field in an Access 2003 database that may have an entry in it, or it may not. Chances are it won't. It is not a required field.

On a form, I want to load this field into a combo box, but what I get is all the entries - both populated and not populated. I don't want the blank entries in my combo. So, I did

SELECT field1 FROM table1 WHERE field1 IS NOT NULL

However, it still returns all the blank, empty, fields. This leads me to believe that even though there is nothing in them, Access thinks they are not null.

How do I return just the actual entries in this field, and not the blank ones?

This is a VBA project. I'm using an Excel 2003 user form (because I think they are far easier to deal with than Access forms.)
 

Introduction to Microsoft Access 2003

Introduction to Microsoft Access 2003 Icon
This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003, emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access.
 

View Queries by Group

View Queries by Group Icon
I have moved from Access 2003 to 2010. In Access 2003 I was able to create query groups that contained shortcuts to queries in the main database. This worked great for us because we did not want to create user interfaces that required support- but we could have multiple queries in a database and have users look only in their query group.

The database I am using was created in 2003 and had those groups. Is there a way to view, edit and create a similar view in 2010?
 

Working with Queries in Access 2003

Working with Queries in Access 2003 Icon
In this section, you'll learn how to: Create queries, Sort results, Add criteria, Employ Boolean operators, Find duplicate records, Create Update queries, Create Delete queries.
 

How to Determine Which Query to Use

How to Determine Which Query to Use Icon
Choosing the right query to use in Access 2003 can save you loads of time. Microsoft Access can seem tricky and complicated, but using queries effectively can make Access 2003 seem a lot simpler. These are the steps to take to determine which query to use in Access 2003.
 

Query or Table Description

Query or Table Description Icon
All my database are developed in Access 2003. When viewing the queries in 2003 there is a 'Description' field. This is always viewable for all queries AND is sortable. I use this field to put my queries sequence. This is how I know the sequence of queries to run - I sort this field.

I also use this field to put notation for Tables.

Now in 2007 this field requires a right click and only one query description is available at a time. So now I'm lost, some of my DB's have up to 100 queries.
 

Count IIf Is NULL

Count IIf Is NULL Icon
I'm trying to use an unbound text field to count all records in a report which have no value (I.e. is null). So far I've got =Count(IIf([JCONTNO]=Null,0)) but it returns 0. I've tried variations but still no joy.

(Using access 2003)