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:

More topics

 

Insert null values for date in ms access 2003

Preview
how to allow null value to be added into database (access 2003)?
The date changed to 11/30/1999 whenever there is null.
 

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

Preview
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 | |
 

multicolumns unique index and null

Preview
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?
 

Microsoft Access 2003 (comprehenisve)

Preview
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.
 

MS Access 2003 - Returning Not Null Field Entires

Preview
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.)
 

Importing text file with blank fields changes to null

Preview
When I import a text file with fields separated by ~ character, if I have a field with blanks, the field in the table appears as null. Also if I have valid characters in the text field plussome spaces at the end, it will trim out those spaces.
I need access to import the field just as it is, respecting any blanks. The field es defined as text. Is there some option I need to set up ? looks like its doing an auto trim. Mi version es Access 2003.
 

Importing text file with blank fields changes to null

Preview
When I import a text file with fields separated by ~ character, if I have a field with blanks, the field in the table appears as null. Also if I have valid characters in the text field plus some spaces at the end, it will trim out those spaces.

I need access to import the field just as it is, respecting any blanks. The field es defined as text. Is there some option I need to set up ? looks like its doing an auto trim. Mi version es Access 2003.
 

Combine two cross table queries to form one table

Preview
I want to combine cross tab queries 1 and 2 so that they form table 3 (below). Could someone help me please?

Table 1
ID FieldA--FieldB--FieldC
1 ---17 ------1------- 23
2--- 6------ 8 --------34
3 ---2------ 1--------- 7

Table 2
ID FieldD--FieldE--FieldF
1-- 4---------- 9-------- 2
2 --19 --------33------ 21
3 --14--------- 7------ 27

Table 3

Table 1
ID FieldA--FieldB--FieldC--FieldD--FieldE--FieldF
1 17 -------1------23 ----NULL----NULL----NULL
2 6------- 8 ------34-----NULL----NULL----NULL
3 2------- 1------- 7---- NULL----NULL----NULL
4 NULL----NULL----NULL----4 -------9------- 2
5 NULL----NULL----NULL----19----- 33 ------21
6 NULL----NULL----NULL----14------ 7------ 27
 

Introduction to Microsoft Access 2003

Preview
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

Preview
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?