In your recordset, use the CONCAT Function to combine the three fields to one:
SELECT CONCAT(numberField, ' ', directionField, ' ', streetname) as address FROM tableName
This will combine the three fields into a new column named "address" you can use the new address column in pro maps.