Find the position of a character in a field

G

Guest

Hi all,

I have a field "ITEM" that contains both an Item Code and Item Description
separated by a space. I need to parse out the Item Code from the ITEM field.
The Item Code is of varying lengths so I need to find the position of the
first occurrence of the space character so that I can use the LEFT()
function. I tried using FIND(" ",[ITEM],1) to no avail. Apparantly can't
do this in ACCESS. How can I accomplish this in an access query??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find xth occurrence of a specifiecd character in a string 3
Opposite of Find Duplicates 1
Separating strings in a field to separate fields 2
Need help with IIf and Trim$ function in a query 6
Query - Table 3
Append two tables into a query 1
query to split fields into multiple rows? 3
Update Value in Table based on to that of Another Field 1

Top