Search results

What is the best way to state this? If [Msampleid1] = "" Then [Mlink2] = "#" & "\customers\" & LCase([Msampleid]) & ".pdf" Else [Mlink2] = "#" & "\customers\" & LCase([Msampleid]) & "-" & LCase([Msampleid1]) & ".pdf" Thanks.

Perfect!

Any examples you could provide?

How can I create an expression in a query that brings back only after the last \? Also, if the field has no value then return a blank or null. \6002.pdf (should look like this) \\SERVER\Plus\Spec\Results\ABC\ABC\Results\6002.pdf Thanks.

Thanks for all the advice on this.

It did not erase the data, it makes it just text and not a hyperlink.

I have a query with a hyperlink field. I want to force lower case but when I do, it removes the hyperlink? What am I doing wrong? History Link: LCase([Mlink3])

Thanks!

Not equal, needs to be contains the word "Apple"

Using conditional formatting, how would the code look if I wanted to find any records in [field1] with the word "Apple" in it. Thanks.

Thank You!

That worked! Thanks!

I'm pulling one record only.

I have a report (onload) that has four fields which are all NOT visible. I would like to make each field visible if the condition is met. If IsNotNull([Mresults1]) And IsNull([Mresults2]) Then [Mresults1].Visible = True If IsNotNull([Mresults2]) And IsNull([Mresults3]) Then [Mresults2].Visible...

Correct.

Any way to make it a hyperlink too?

Works Great! One question though... The field [Link] is a hyperlink but when I use this code, it does not keep any hyperlink.

Can you show me how that code would look in the query?

I have a field called [Link] and the data looks like this... \customers\tomsmith\pdf\1234.pdf In a query, how can I create a field that removes everything up to the pdf? \customers\tomsmith\pdf Thanks

Perfect!!!