UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Separate Text In Query Design, Windows 7    
 
   
Quinto1
post May 17 2018, 11:00 AM
Post#1



Posts: 113
Joined: 23-April 16



I would like use a query to select text in an separate control field before the symbol "/"
Can I get some suggestion how by using the query design without using code

Thank you
Go to the top of the page
 
 
Start new topic
Replies
theDBguy
post May 17 2018, 11:06 AM
Post#2


UA Moderator
Posts: 77,727
Joined: 19-June 07
From: SunnySandyEggo


Hi,

You could try using the InStr() function in your query. For example:

Left$([FieldName], InStr([FieldName], "/")-1)

Hope it helps...
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    4th April 2020 - 04:25 PM