How to select the first of multiple answers returned in a query.

Question

How can I select the first result found in a query with multiple results?
In the example below, the 'Correct Hauler Name' column is a query that searches for values containing: {#Column Number# .CT. [Hauler]} within the .I get Multiple values in the column 'Correct Hauler Name', I need only the first value the query founds.------------------------------Cristian Carrion------------------------------

AdamKrzyzanek · Answer

You can use formula Part.If result is formula query, then you may need to convert it first ToText.Example Code://without ConversionPart([Correct Hauler Name],1,";")//with ConversionPart(ToText([Correct Hauler Name]),1,";")------------------------------Adam Krzyzanek------------------------------

Sign up

Login to the community