Asterisk Database Variable

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

In my tables, the asterisk is an important value of a
variable (it's an examination grade!). How can I get
Access to accept the literal value of * rather than
interpreting it as any number of any characters?

All help appreciated - as ever!
 
Use = for equal, or <> for not equal instead of Like.

If you need to use the Like operator, you can use the literal asterisk in
square brackets, e.g.:
Like "computers use [*] for multiplication"
 
Back
Top