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
------------------------------
Original Message:
Sent: 09-17-2023 21:17
From: Cristian Carrion
Subject: 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 [Table with a list of names].
I get Multiple values in the column 'Correct Hauler Name', I need only the first value the query founds.
------------------------------
Cristian Carrion
------------------------------