Link to home
Start Free TrialLog in
Avatar of Amour22015
Amour22015

asked on

MS Access Report - Address

Hi Experts,

I have this in Access:
[Address1] & [Address2] & [City] & [State] & [ZipCode] & [Country]

And I take them from a SP.

But none check for blanks in the fields, so I would need some Format to check for Nulls or blanks ?
example:
Address1 = 999 Smith Street
Address2 = Blank
City = Washington
State = DC
ZipCode = 99999
Country = USA
Or
Address1 = 999 Smith Street
Address2 = Blank
City = Blank
State = Blank
ZipCode = 99999
Country = DE


Please help and thanks...
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amour22015
Amour22015

ASKER

Great Thanks