1 Replies - 676 Views - Last Post: 01 June 2016 - 05:51 AM

#1 WoodBonnie  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 26-May 16

Filtering Data in the MS Access ‘Query Design’ View

Posted 01 June 2016 - 12:59 AM

I'm trying to filter some data based on a '0' being the middle character of a 5 character string. Trying a filter based on the usual wildcard character won't work, as Like
"*0*"
will pretty much pick up a zero anywhere. Can anyone suggest how I narrow things down to just that central position? :helpsmilie:

Is This A Good Question/Topic? 0
  • +

Replies To: Filtering Data in the MS Access ‘Query Design’ View

#2 andrewsw  Icon User is offline

  • say what now
  • member icon

Reputation: 6409
  • View blog
  • Posts: 25,903
  • Joined: 12-December 12

Re: Filtering Data in the MS Access ‘Query Design’ View

Posted 01 June 2016 - 05:51 AM

You can use Like "??5??" where the question marks are placeholders for a single character.

If the other characters are also numbers, digits, then you could instead use Like "##5##".

LIKE condition (using wildcards)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1