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...
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER