Slight Problem With Syntax In VBA . .

[Evagrius]

Hi all,

Again I am blighted my eroneous syntax. Can anyone help please? I simply would like to use the "LIKE" operator to select only Assets that begin with XX.

I would also be grateful if someone could show me how to include an "AND"; this way I can have "LIKE" XX and LIKE AB"

Private Sub MyND_Click()
DoCmd.OpenReport "Fin Est", acViewReport, , "[Asset Number] Like XX" & "&*"""

End Sub

 

[boblarson]

DoCmd.OpenReport "Fin Est", acViewReport, , "[Asset Number] Like 'XX*'"

 

[boblarson]

Oops missed the second part (don't you want OR AB there?):

DoCmd.OpenReport "Fin Est", acViewReport, , "[Asset Number] Like 'XX*' OR [Asset Number] Like 'AB*'"

Or if you are wanting these anywhere in the Asset Number then you can use:

DoCmd.OpenReport "Fin Est", acViewReport, , "[Asset Number] Like '*XX*' And [Asset Number] Like '*AB*'"

 

[Evagrius]

Bob - you are a true gentleman sir and a descendant of ancient, royal and conquering warriors

Also, you are correct, I did mean OR and not AND since AND would have always returned 0 records. "OR" will be the one to return all records that begin with XX or AB.

Thank you Bob!!!