Forum Discussion

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

.

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



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

1 Reply

Sort By
  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    8 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
    ------------------------------