Re: Null Expression

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In order to post the SQL statement, you need to switch the query to SQL
View, via the View menu, or the toolbar button, or the right-click context
menu.

Steve wrote:
Excuse me, I thought that was enough information. Here is the
expression that I've been using but it doesn't work. Expr1:
IIf(IsNull([Location Codes]![Location Name], " ", [Location
Codes]![Location Name]). The data field that is blank is in another
table but I want the location name to always populate. I don't even
know if I am placing this expression in the correct place. Should it
be in the field or criteria row.



"Jeff Boyce" wrote:

We aren't there. We can't see your data. We don't know your
subject area.

Please post the SQL statement your query uses...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DA7E02DE-A31E-4E97-AD25-406E07E9E214@xxxxxxxxxxxxxxxx
I'm an access novice, but I've created a query using two tables,
"Location"
and "Products Shipped". The query works fine but not all of the
locations ship all of the products. I want the "Location" table to
populate with the
field name when I run the query. I've tried several IIF(IsNull)
expressions
but I can't get it to work.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Quantcast