I have created a new 'view' to list our inventory, total sold last year and current stock. Now I'm trying to add a filter so that I can show all items starting with EEZ but it's not working. I went into the filter screen - choose field {item #}and now I'm stuck.

I thought it should be something like:
{Item #}=(EEZ)

Are you able to help?

Thanks
Diane

Try:
Left({Item #},3)= "EEZ"

Thanks Micheal, but still not working. Now at least I can verify OK, but when I toggle, it closes all information. So I get all or nothing.

Diane

Hi Diane,

It may be that the number of characters used for your item number codes are such that the first 3 characters stored in the database are not EEZ but perhaps spaces.

Try using the Trim function to remove any leading or trailing spaces, something like this:

Left(Trim({Item #}),3)= "EEZ"

Great! It's working! Thanks for your help