if first letter is not a \

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with an if statement in a query.


if the first letter of the field "photo" is not a \ then call the function
"fgetUNCPath" else do nothing
 
If .. Then... Else is not a typical query setup. Are you wanting to get the
value for a calculated field, and either wanting it to be the value from the
function, or .. .what ... if photo doesn't begin with the letter a? Please
give us more details about what your setup is and how you want to use this.
 
I need help with an if statement in a query.

if the first letter of the field "photo" is not a \ then call the function
"fgetUNCPath" else do nothing
Click to expand...

An If statement in a query?
Queries do not support If.

You can use IIF.

I'll assume fgetUNCPath does not require any arguments, as you haven't
stated any.

Exp:IIf(Left([Photo],1) = "\" ,"",fgetUNCPath())
 
You must log in or register to reply here.

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

Change the color of each capital letter in a rich text memo field. 0
How to type each letter of the alphabet automatically in a specific color in Word? 0
Change from all UPPER case letters 5
Auto fill not working 2
add function results to the table field using a form 3
Capitalizing first letter of data in a query 1
First Letter Uppercase 1
Extracting the few letters after the comma 5

Back
Top