I have a field in a table named ItemData that returns multiple items... i.e.
R431161|,||,|True|,||,|False
I am looking to show in the query results only the data before the first space, which would be the account number only in this case. The account number (Rnumber) can be 6 or seven digits...