Problems with a IIF, thanks

[pgarcia]

My query BAXSaver Canada has 4224 line of data. I'm trying to creat another
query change changes my 4 to 3, but I'm getting back fewer lines (3734). Why?

IIf([BAXSaver Canada]![Field3]=4,3,[BAXSaver Canada]![Field3])

 

[KARL DEWEY]

Seems like you may have some records that Field3 is null. Check and see.

 

[pgarcia]

Sorry, the field is full of data.

Seems like you may have some records that Field3 is null. Check and see.
--
KARL DEWEY
Build a little - Test a little

My query BAXSaver Canada has 4224 line of data. I'm trying to creat another
query change changes my 4 to 3, but I'm getting back fewer lines (3734). Why?

IIf([BAXSaver Canada]![Field3]=4,3,[BAXSaver Canada]![Field3])

 

[John Spencer]

Would you care to share the SQL view of your query?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[pgarcia]

Ok, I was doing the expression within the field. When I put it in an empty
field, it worked. Why is that?

And, do you know VB for Access?

Would you care to share the SQL view of your query?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

My query BAXSaver Canada has 4224 line of data. I'm trying to creat another
query change changes my 4 to 3, but I'm getting back fewer lines (3734). Why?

IIf([BAXSaver Canada]![Field3]=4,3,[BAXSaver Canada]![Field3])