[AccessD] Put humpty dumpty back together again

I'm assuming your using Access queries to do this:

SELECT HouseNumberPrefix, HouseNumber, HouseNumberSuffix, Direction,
StreetName, Mode , Quadrant, Appt# ([HouseNumberPrefix]+" ") &
([HouseNumber]+" ") & ([HouseNumberSuffix]=" ") & ([Direction]=" ") &
([StreetName]=" ") & ([Mode ]=" ") & ([Quadrant]=" ") & [Appt#] AS
FullAddress
FROM tblPerson

HTH
John B.