filter with wildcard

[ECEK]

Hi All
I want to capture all variables that begin with the word "Pre"

DoCmd.ApplyFilter , "Status = 'Pre*'"

I'm a bit confused by & and '''''''' and """""""""
Is there a go to place to learn the syntax?

Thanks in advance

 

[The_Doc_Man]

When you need to know some really good stuff about Access, Allen Browne is always a good source. Try this article:

http://allenbrowne.com/casu-17.html

 

[MajP]

If building any sql or where clause wrap in single qoutes.
No need to ever do '''''''' and """""""". Confusing and waste of time.

 

[ECEK]

Thanks Doc. I'm still struggling though!!!

 

[ECEK]

I'm confused by the use of single and double quotes. Could somebody please help me with my syntax.
Thanks

 

[MajP]

Maybe a bunch of examples will help. See where you are confused

Public Sub Test2()
  'you wrap a string in double quotes to make a string
  'You wrap a literal in a string in single quotes
  Dim str As String
  str = "Hello world"
  Debug.Print str
  str = "Hello 'Happy' world"
  Debug.Print str
  Debug.Print str & " '"; Date & "'"
  Debug.Print str
  Debug.Print "'ABC'"
  Debug.Print """ABC"""
  Debug.Print """" & "ABC" & """"
  Debug.Print str & " and new string 'somethinginSingleQuotes'" & """ somethingindoublequotes """
End Sub

Hello world
Hello 'Happy' world
Hello 'Happy' world '1/24/2019'
Hello 'Happy' world
'ABC'
"ABC"
"ABC"
Hello 'Happy' world and new string 'somethinginSingleQuotes'" somethingindoublequotes "

 

[ECEK]

Figured it out:

DoCmd.ApplyFilter , "Status Like 'Pre*' "