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, I need only the first value the query founds.
------------------------------Cristian Carrion------------------------------

chayceduncan · Answer

You can do a Part function and split on the ;

Formula queries return a ; delimited list, so doing the part at the first occurrence using the ; as the split will give you what you need. So in your correct hauler name:&nbsp;

Part(query results value,&nbsp;1, ";")------------------------------Chayce Duncan------------------------------

cristiancarrion · Answer

Great works perfectly, Thanks so much!!&nbsp; :)&nbsp;------------------------------Cristian Carrion------------------------------

Forum Discussion

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

Related Content

Pipeline Make Request - Return Make Request JSON Output into fields

Check one field for multiple conditions

Building a report from multiple tables

Lookup multiple items from the same table.

Multiple reference proxy fields help

Recent Discussions

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns