[AccessD] Put humpty dumpty back together again

John Bartow john at winhaven.net
Fri Jun 6 10:04:33 CDT 2008


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.




More information about the AccessD mailing list