Selecting records that start with two asterisks and a spacebar

  • Thread starter Thread starter Morris
  • Start date Start date
M

Morris

Hi!

I'm trying to show only the text fields which start with "** " - how
should I 'escape' the asterisks and the spacebar?
 
Morris said:
Hi!

I'm trying to show only the text fields which start with "** " - how
should I 'escape' the asterisks and the spacebar?
Click to expand...

yup, LIKE "[*][*] *" works :)

cheers
 
Add a field in the design grid like this --
JustChecking: Left([YourField],3)
Use this as criteria --
"** "
 
Back
Top