Forum Discussion

Qrew Member

12 months ago

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

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...

AdamKrzyzanek

Qrew Captain

12 months ago

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
------------------------------