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

Pipeline Make Request - Return Make Request JSON Output into fields

Multiple reference proxy fields help

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

Managing record access for multiple data levels

New Forms Return and Cancel Buttons Glitch

Recent Discussions

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

Quickbase JMP connection