Conditional consolidation of two fields down to one

  • Thread starter Thread starter Sam Carleton
  • Start date Start date
S

Sam Carleton

I have a simply problem that hopefully has a simple solution. I
have two fields, one is mailing address, the other is street
address. In this table, most rows only have a street address,
but a few folks have a different mailing mailing address (mostly
PO Boxes). I want to use the street address if the mailing
address is null. How do I do this in a queue? I am pictureing
something like this:

if mailing is null then street else mailing

But how does one do that in an Access Queue?
 
Sam,

Select NZ([MailingAddress], [StreetAddress]) as Address, from yourtable
Click to expand...

this works GREATE from within an Access Queue, but when I try to
select the view from an external program, like MS Word where I am
trying to do a mailing list, I get an error about the NZ.

Is there any way to use NZ through ODBC?

Sam
 
I love it when I can answer my own question:

SELECT IIf(IsNull(mailing_address),street,mailing_address) AS
address FROM <table>

Sam,

Select NZ([MailingAddress], [StreetAddress]) as Address, from yourtable
Click to expand...

this works GREATE from within an Access Queue, but when I try to
select the view from an external program, like MS Word where I am
trying to do a mailing list, I get an error about the NZ.

Is there any way to use NZ through ODBC?

Sam
Click to expand...
 
Back
Top