Sql statement

[momo]

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Wayne]

Are you sure you don't need to use a LIKE

For Middle Names that begin with:
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName like 'M%' "

For Middle Names that contain (any where)
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName like '%M%' "

For Middle Names that end with...
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName like '%M' "
-Wayne
"momo" <ma***@seeourweb.com> wrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[momo]

Thank for replying Wayne.

No, I need to retrieve only the records without any MiddleName. I am looking
for blank MiddleNames.

"Wayne" <wa***@nospam.cfwebmasters.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Are you sure you don't need to use a LIKE

For Middle Names that begin with:
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like 'M%' "

For Middle Names that contain (any where)
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M%' "

For Middle Names that end with...
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M' "
-Wayne
"momo" <ma***@seeourweb.com> wrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Brad Roberts]

Try using where len(ltrim(MiddleName)) = 0...

[David Hogue]

momo wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='' "

Is MiddleName null?

Try "... where MiddleName = null" or "... where MiddleName is null".

I haven't used Access much, so I'm not sure on the syntax.
--
David Hogue

[sloan]

If the value is null (in the db), an empty string is NOT the same thing as
null.

I'm not super sure with access, but I think the query is

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,

Phone from Employee where MiddleName IS NULL"
that's the sql server syntax, I think access is the same.

"Wayne" <wa***@nospam.cfwebmasters.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl... Are you sure you don't need to use a LIKE

For Middle Names that begin with:
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode, Phone from Employee where MiddleName like 'M%' "

For Middle Names that contain (any where)
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode, Phone from Employee where MiddleName like '%M%' "

For Middle Names that end with...
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode, Phone from Employee where MiddleName like '%M' "
-Wayne
"momo" <ma***@seeourweb.com> wrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no value in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Wayne]

Sorry, I misread that.

Try testing for length after triming trailing spaces. I believe the syntax
is:

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where len(ltrim(MiddleName)) = 0"

"momo" <ma***@seeourweb.com> wrote in message
news:uc*************@TK2MSFTNGP05.phx.gbl...

Thank for replying Wayne.

No, I need to retrieve only the records without any MiddleName. I am
looking for blank MiddleNames.

"Wayne" <wa***@nospam.cfwebmasters.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Are you sure you don't need to use a LIKE

For Middle Names that begin with:
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like 'M%' "

For Middle Names that contain (any where)
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M%' "

For Middle Names that end with...
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M' "
-Wayne
"momo" <ma***@seeourweb.com> wrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[momo]

I tried that already and it did not work.

"David Hogue" <da************@gmail.com> wrote in message
news:2Z*****************@fe09.news.easynews.com...

momo wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='' "

Is MiddleName null?

Try "... where MiddleName = null" or "... where MiddleName is null".

I haven't used Access much, so I'm not sure on the syntax.
--
David Hogue

[momo]

Did not work

"Brad Roberts" <Br*****************@hotmail.com> wrote in message
news:2E**********************************@microsof t.com...

Try using where len(ltrim(MiddleName)) = 0...

[momo]

Still won't work

"Wayne" <wa***@nospam.cfwebmasters.com> wrote in message
news:Ob**************@TK2MSFTNGP04.phx.gbl...

Sorry, I misread that.

Try testing for length after triming trailing spaces. I believe the
syntax is:

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where len(ltrim(MiddleName)) = 0"

"momo" <ma***@seeourweb.com> wrote in message
news:uc*************@TK2MSFTNGP05.phx.gbl...

Thank for replying Wayne.

No, I need to retrieve only the records without any MiddleName. I am
looking for blank MiddleNames.

"Wayne" <wa***@nospam.cfwebmasters.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Are you sure you don't need to use a LIKE

For Middle Names that begin with:
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like 'M%' "

For Middle Names that contain (any where)
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M%' "

For Middle Names that end with...
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName like '%M' "
-Wayne
"momo" <ma***@seeourweb.com> wrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...
Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode, Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Peter Bromberg [C# MVP]]

Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to work.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"momo" wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Jan Hyde]

Peter Bromberg [C# MVP] <pb*******@yahoo.nospammin.com>'s
wild thoughts were released on Wed, 24 May 2006 18:10:02
-0700 bearing the following fruit:

Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to work.

Yea, but how's he gonna write the WHERE clause for the
UPDATE statment ;-)

LOL.

Jan Hyde (VB MVP)

--
Every morning is the dawn of a new error. (Don Thorn)

[momo]

No that will not work for me. So does this mean that there is no way to do
this? It seem so simple.

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F5**********************************@microsof t.com...

Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to
work.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"momo" wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

[Jan Hyde]

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 08:36:19 -0400 bearing the following
fruit:

No that will not work for me. So does this mean that there is no way to do
this? It seem so simple.
It is simple. What your saying just doesn't add up though.

What database are you using?

J
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F5**********************************@microso ft.com...

Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to
work.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"momo" wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

Jan Hyde (VB MVP)

--
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves)

[momo]

MS Access
"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:m4********************************@4ax.com...

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 08:36:19 -0400 bearing the following
fruit:

No that will not work for me. So does this mean that there is no way to do
this? It seem so simple.

It is simple. What your saying just doesn't add up though.

What database are you using?

J

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F5**********************************@micros oft.com...

Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to
work.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"momo" wrote:

Can someone tell me why my query returns nothing?

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='' "

However this works fine.
"Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
Zipcode,
Phone from Employee where MiddleName ='M' "

I have checked the Employee table and I have several records with no
value
in the MiddleName column.

I am using MS Access'

Please help this is driving me crazy.

Jan Hyde (VB MVP)

--
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves)

[Jan Hyde]

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 10:12:05 -0400 bearing the following
fruit:

MS Access

Well I don't know Access but assuming you do, can you
determine if the MiddleName field of the Emplyee table
allows NULL values?

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:m4********************************@4ax.com.. .

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 08:36:19 -0400 bearing the following
fruit:

No that will not work for me. So does this mean that there is no way to do
this? It seem so simple.

It is simple. What your saying just doesn't add up though.

What database are you using?

J

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F5**********************************@micro soft.com...
Jeesh!
Try replacing all the empty middle names with space (' '). That HAS to
work.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"momo" wrote:

> Can someone tell me why my query returns nothing?
>
> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
> Zipcode,
> Phone from Employee where MiddleName ='' "
>
> However this works fine.
> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
> Zipcode,
> Phone from Employee where MiddleName ='M' "
>
> I have checked the Employee table and I have several records with no
> value
> in the MiddleName column.
>
> I am using MS Access'
>
> Please help this is driving me crazy.
>
>
>

Jan Hyde (VB MVP)

--
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves)

Jan Hyde (VB MVP)

--
Lottery: A tax on people who are bad at math.

[momo]

Yes it does and I have tried to use NULL in the statement and it will not
work either.
"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:ov********************************@4ax.com...

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 10:12:05 -0400 bearing the following
fruit:

MS Access

Well I don't know Access but assuming you do, can you
determine if the MiddleName field of the Emplyee table
allows NULL values?

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:m4********************************@4ax.com. ..

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 08:36:19 -0400 bearing the following
fruit:

No that will not work for me. So does this mean that there is no way to
do
this? It seem so simple.

It is simple. What your saying just doesn't add up though.

What database are you using?

J

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
message
news:F5**********************************@micr osoft.com...
> Jeesh!
> Try replacing all the empty middle names with space (' '). That HAS to
> work.
>
> Peter
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
>
>
> "momo" wrote:
>
>> Can someone tell me why my query returns nothing?
>>
>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>> Zipcode,
>> Phone from Employee where MiddleName ='' "
>>
>> However this works fine.
>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>> Zipcode,
>> Phone from Employee where MiddleName ='M' "
>>
>> I have checked the Employee table and I have several records with no
>> value
>> in the MiddleName column.
>>
>> I am using MS Access'
>>
>> Please help this is driving me crazy.
>>
>>
>>

Jan Hyde (VB MVP)

--
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves)

Jan Hyde (VB MVP)

--
Lottery: A tax on people who are bad at math.

[Jan Hyde]

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 11:28:27 -0400 bearing the following
fruit:

Yes it does and I have tried to use NULL in the statement and it will not
work either.
Post the exact SQL you used.

Also, when you say the query returned no rows, how did you
determine this?

J
"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:ov********************************@4ax.com.. .

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 10:12:05 -0400 bearing the following
fruit:

MS Access

Well I don't know Access but assuming you do, can you
determine if the MiddleName field of the Emplyee table
allows NULL values?

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:m4********************************@4ax.com ...
"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 08:36:19 -0400 bearing the following
fruit:

>No that will not work for me. So does this mean that there is no way to
>do
>this? It seem so simple.

It is simple. What your saying just doesn't add up though.

What database are you using?

J

>"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
>message
>news:F5**********************************@mic rosoft.com...
>> Jeesh!
>> Try replacing all the empty middle names with space (' '). That HAS to
>> work.
>>
>> Peter
>> --
>> Co-founder, Eggheadcafe.com developer portal:
>> http://www.eggheadcafe.com
>> UnBlog:
>> http://petesbloggerama.blogspot.com
>>
>>
>>
>>
>> "momo" wrote:
>>
>>> Can someone tell me why my query returns nothing?
>>>
>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>> Zipcode,
>>> Phone from Employee where MiddleName ='' "
>>>
>>> However this works fine.
>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>> Zipcode,
>>> Phone from Employee where MiddleName ='M' "
>>>
>>> I have checked the Employee table and I have several records with no
>>> value
>>> in the MiddleName column.
>>>
>>> I am using MS Access'
>>>
>>> Please help this is driving me crazy.
>>>
>>>
>>>
>
Jan Hyde (VB MVP)

--
A friend of mine just had her 11th baby. Everyone says she's overbearing
(Megan Waves)

Jan Hyde (VB MVP)

--
Lottery: A tax on people who are bad at math.

Jan Hyde (VB MVP)

--
Nostalgia is like a grammar lesson: You find the present tense and the past perfect. (Catherine Shoemaker)

[momo]

I have a datagrid to is suppose to display the records found and it does not
display any record when I use

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName =''' '"

But works when I use

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='''M''"

Thanks for helping me with this.

Momo.

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:2g********************************@4ax.com...

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 11:28:27 -0400 bearing the following
fruit:

Yes it does and I have tried to use NULL in the statement and it will not
work either.

Post the exact SQL you used.

Also, when you say the query returned no rows, how did you
determine this?

J

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:ov********************************@4ax.com. ..

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 10:12:05 -0400 bearing the following
fruit:

MS Access
Well I don't know Access but assuming you do, can you
determine if the MiddleName field of the Emplyee table
allows NULL values?
"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:m4********************************@4ax.co m...
> "momo" <ma***@seeourweb.com>'s wild thoughts were released
> on Thu, 25 May 2006 08:36:19 -0400 bearing the following
> fruit:
>
>>No that will not work for me. So does this mean that there is no way
>>to
>>do
>>this? It seem so simple.
>
> It is simple. What your saying just doesn't add up though.
>
> What database are you using?
>
> J
>
>>"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
>>message
>>news:F5**********************************@mi crosoft.com...
>>> Jeesh!
>>> Try replacing all the empty middle names with space (' '). That HAS
>>> to
>>> work.
>>>
>>> Peter
>>> --
>>> Co-founder, Eggheadcafe.com developer portal:
>>> http://www.eggheadcafe.com
>>> UnBlog:
>>> http://petesbloggerama.blogspot.com
>>>
>>>
>>>
>>>
>>> "momo" wrote:
>>>
>>>> Can someone tell me why my query returns nothing?
>>>>
>>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>>> Zipcode,
>>>> Phone from Employee where MiddleName ='' "
>>>>
>>>> However this works fine.
>>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>>> Zipcode,
>>>> Phone from Employee where MiddleName ='M' "
>>>>
>>>> I have checked the Employee table and I have several records with
>>>> no
>>>> value
>>>> in the MiddleName column.
>>>>
>>>> I am using MS Access'
>>>>
>>>> Please help this is driving me crazy.
>>>>
>>>>
>>>>
>>
>
>
> Jan Hyde (VB MVP)
>
> --
> A friend of mine just had her 11th baby. Everyone says she's
> overbearing
> (Megan Waves)
>

Jan Hyde (VB MVP)

--
Lottery: A tax on people who are bad at math.

Jan Hyde (VB MVP)

--
Nostalgia is like a grammar lesson: You find the present tense and the
past perfect. (Catherine Shoemaker)

[Jan Hyde]

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Fri, 26 May 2006 11:20:11 -0400 bearing the following
fruit:

I have a datagrid to is suppose to display the records found and it does not
display any record when I use

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName =''' '"

But works when I use

"Select EmployeeID, SSN, LastName, FirstName, Address, City, State, Zipcode,
Phone from Employee where MiddleName ='''M''"

Thanks for helping me with this.
Then the first thing we need to do is eliminate the SQL as
the cause of the problem. Presumably there is some way you
can pull back results for a given SQL in access itself?

See if you get any results, if you do get results then you
need to post more of your code.

J
Momo.

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:2g********************************@4ax.com.. .

"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 11:28:27 -0400 bearing the following
fruit:

Yes it does and I have tried to use NULL in the statement and it will not
work either.

Post the exact SQL you used.

Also, when you say the query returned no rows, how did you
determine this?

J

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:ov********************************@4ax.com ...
"momo" <ma***@seeourweb.com>'s wild thoughts were released
on Thu, 25 May 2006 10:12:05 -0400 bearing the following
fruit:

>MS Access
>

Well I don't know Access but assuming you do, can you
determine if the MiddleName field of the Emplyee table
allows NULL values?
>"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
>news:m4********************************@4ax.c om...
>> "momo" <ma***@seeourweb.com>'s wild thoughts were released
>> on Thu, 25 May 2006 08:36:19 -0400 bearing the following
>> fruit:
>>
>>>No that will not work for me. So does this mean that there is no way
>>>to
>>>do
>>>this? It seem so simple.
>>
>> It is simple. What your saying just doesn't add up though.
>>
>> What database are you using?
>>
>> J
>>
>>>"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
>>>message
>>>news:F5**********************************@m icrosoft.com...
>>>> Jeesh!
>>>> Try replacing all the empty middle names with space (' '). That HAS
>>>> to
>>>> work.
>>>>
>>>> Peter
>>>> --
>>>> Co-founder, Eggheadcafe.com developer portal:
>>>> http://www.eggheadcafe.com
>>>> UnBlog:
>>>> http://petesbloggerama.blogspot.com
>>>>
>>>>
>>>>
>>>>
>>>> "momo" wrote:
>>>>
>>>>> Can someone tell me why my query returns nothing?
>>>>>
>>>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>>>> Zipcode,
>>>>> Phone from Employee where MiddleName ='' "
>>>>>
>>>>> However this works fine.
>>>>> "Select EmployeeID, SSN, LastName, FirstName, Address, City, State,
>>>>> Zipcode,
>>>>> Phone from Employee where MiddleName ='M' "
>>>>>
>>>>> I have checked the Employee table and I have several records with
>>>>> no
>>>>> value
>>>>> in the MiddleName column.
>>>>>
>>>>> I am using MS Access'
>>>>>
>>>>> Please help this is driving me crazy.
>>>>>
>>>>>
>>>>>
>>>
>>
>>
>> Jan Hyde (VB MVP)
>>
>> --
>> A friend of mine just had her 11th baby. Everyone says she's
>> overbearing
>> (Megan Waves)
>>
>
Jan Hyde (VB MVP)

--
Lottery: A tax on people who are bad at math.

Jan Hyde (VB MVP)

--
Nostalgia is like a grammar lesson: You find the present tense and the
past perfect. (Catherine Shoemaker)

Jan Hyde (VB MVP)

--
Toothache: The pain that drives you to extraction. (Goeff Tibballs)