PC Review


Reply
Thread Tools Rate Thread

compare two fields

 
 
=?Utf-8?B?UmF5IE1lYWQ=?=
Guest
Posts: n/a
 
      17th Jun 2005
Hi there, I have a query to compare two different fields, state and
originalstate. It works fine if the data is changed, but the query does not
include records where one of the fields is null. How do I include the null
values?

Thanks
 
Reply With Quote
 
 
 
 
=?Utf-8?B?S2xhdHV1?=
Guest
Posts: n/a
 
      17th Jun 2005
Try this:

Nz([state],"")
Nz([originalstate],"")

I am assuming they are both text fields, if they are number, replace "" with 0
"Ray Mead" wrote:

> Hi there, I have a query to compare two different fields, state and
> originalstate. It works fine if the data is changed, but the query does not
> include records where one of the fields is null. How do I include the null
> values?
>
> Thanks

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Fields =?Utf-8?B?TGlnaHRTaG93?= Microsoft Access 1 27th Dec 2006 03:08 AM
Compare fields =?Utf-8?B?RGF2ZVVL?= Microsoft Access VBA Modules 1 7th Jun 2006 12:01 PM
compare fields =?Utf-8?B?YWxhdmF6MTc=?= Microsoft Access Queries 4 15th Jun 2005 05:21 PM
Compare fields David F-B Microsoft Access 4 28th Apr 2004 08:01 PM
Compare 2 fields and then ouput 1 of 2 fields Steve Microsoft Access Queries 2 22nd Nov 2003 03:51 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:41 PM.