SOLVED - Filtering Data in the MS Access 'Query Design' View

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?

The string is always 5 characters?
Try https://support.office.com/en-us/article/Left-Function-d5897bf6-91f5-4bf8-853a-b63d7de09681

1 Like

I got an answer that works from someone in the office with way more chops than I. Apparently, the following works with a criteria of 0. cost centre is the column I’m filtering on

Expr1: Mid([cost centre],3,1)

I’ll get to explain how it works to me later.

Thanks for the link, it guided me towards this instead - https://msdn.microsoft.com/en-us/library/gg251677.aspx

Ah yes of course, MID, sorry
For some reason I thought you could give the starting position to LEFT as well :expressionless:

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.