Help with a merged field into a calculation

[ultrex]

Hi Guys,

Im stuck with this calculation (even if it is one). I have a 'street location field' which is a drop down - from a merged field containing the street & suburb into the one field. This is created via a portal. I have a design run sheet that displays the locations etc that was put in from the portal. But In the run sheet, I dont want to display the 'merged field' instead just showing me the street (without the suburb). How do I go around this??

[Ender]

Enter the data using separate fields for Street and Suburb. Then where it's desirable to have them combined, either merge them on the layout (using merge fields), or use a calc that concatenates them.