Forum Discussion

CristianCarrion's avatar
CristianCarrion
Qrew Member
2 years 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. [Hauler]} within the

.

I get Multiple values in the column 'Correct Hauler Name', I need only the first value the query founds.



------------------------------
Cristian Carrion
------------------------------

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