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 Conversion
Part([Correct Hauler Name],1,";")

//with Conversion
Part(ToText([Correct Hauler Name]),1,";")
------------------------------Adam Krzyzanek------------------------------

Forum Discussion

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