Null as Character in MS ACCESS 2003 Queries

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:

Related Topics

Insert null values for date in ms access 2003
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)
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
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)
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.


Importing text file with blank fields changes to null
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
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
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


MS Access 2003 - Returning Not Null Field Entires
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.)


Strings which contain Nulls
I am querying full postcodes in our database and it appears some of the postcodes contain a null character as opposed to a space between the first and second part of the postcode.

For example, If use the Ascii Tool on http://a.com/ascii-hex.php to convert 'GL7 7JY', it returns the Ascii codes 71 76 55 NULL 55 74 89

Even posting the string on this forum, the Null gets converted to an asterisk.

Is there a way to query all records which contain a Null as part of the string


Microsoft Access 2003 Import Issue- randomly cutting out first character
Whenever I try to import a file in Microsoft Access 2003 (txt, csv, excel) it'll randomly cut off the first character of some of the columns. For example, I have a file with 300,000 rows and states are listed. About 200 of the states are imported as "labama" or "lorida." It seems like this error is completely random. I just patched Microsoft Office and it's still doing it. Anybody know what to do


Character limit in form field
I have created a form in Access 2003. One of the fields titled "Description" typically will have more than one line of information entered into it. Right now, there appears to be a character limit.

It does not allow me to enter any information beyond just one line. Is there any way to extend the character limit of this field, or even better, make it unlimited?


Upper and Lower case characters a challenge!
I'm not a programmer and have searched for so many hours trying to figure out if there's any way I can get MS Access queries to not see matches when alphanumeric character strings vary by only one uppercase character (or lowercase character).

I have 15 characters that generally the last 4 change, mostly the last 2, but are two separate records separated by one character, eg, XXXXXXXXXXXXXXB and XXXXXXXXXXXXXXXb. I'm trying to link over a million records with these type of id's and have permanent keyboard imprints on my forehead.

I couldn't possibly be the only one out here with this issue? Anyone encounter this and figure it out? I would really, really, realllllly, REALLLY appreciate the help.

Trying to find the light upper and lower case way,


Introduction to Microsoft Access 2003
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
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?


View Queries by Group
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?


Add a check mark via vb
I want to add a button to a form that, if clicked, will add a check mark to a field. There is a wingdings checkmark character, but:
1. I can't figure out how to use vb to get the wingdings character into the field.I can insert it using the windows xp character map application, but.character map says it's character code is OxFC, but where does that get me? asc("OxFC") returns 79.

2. I don't really want to set the font to wingdings because I also need the ability to type normal characters into the field. I suppose I could set up vb to change the font, but.

is there a better way?

Access 2003, WIndows XP


updating field whose value is the word NULL and Not a typical 'null' value
I was given a table where in a text field, the value is NULL. (Actually spelled out like that.)
I need to convert that field to a date/time one. Which is being hindered by these values of NULL.

The problem is that when I put the word NULL in the field criteria spot, Access believes that I am referring to a value of 'null' and will not do the update.
I have done "NULL", NULL, =NULL, ="NULL", is NULL. and no success.
Please remember that the actual value is not 'null'. It is a text field that has the word NULL in the field.


Working with blank fields
I have a field where the output appears blank but is not a null character. How do I query to get the blank data when it is not null?


Query or Table Description
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.


Working with Queries in Access 2003
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.