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.

2 Replies

Related Content

Code Page for User to Search And Return Value

Interview form using multiple tables

Using Grid Edit to Edit Multiple Records at Once

Pipeline Make Request - Return Make Request JSON Output into fields

Formula-Numeric Field Returning Null Instead of 0

Recent Discussions

Using Timelines

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

Expanded URL from Reports

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

View query record if single record otherwise view query list