Access Quarry

%3CLINGO-SUB%20id%3D%22lingo-sub-1160447%22%20slang%3D%22en-US%22%3EAccess%20Quarry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1160447%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20quarry%20of%20all%20our%20engineering%20projects%20by%20year.%20when%20I%20open%20the%20quarry%202019%20Projects%20and%20change%20the%20criteria%20from%20Like%20*19*%22%20to%20Like%20%2220*%22%20and%20I%20select%20the%20Run%20button%20none%20of%20the%20five%202020%20projects%20are%20shown%20in%20the%202020%20Projects%20Quarry%20after%20I%20close%20it%20and%20then%20open%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1160447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1162073%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Quarry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549210%22%20target%3D%22_blank%22%3E%40Larrym3525%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20%3CEM%3E%3D2020%3C%2FEM%3E%20or%2C%20if%20the%20field%20is%20text%2C%20%3CEM%3E%3D'2020'%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a quarry of all our engineering projects by year. when I open the quarry 2019 Projects and change the criteria from Like *19*" to Like "20*" and I select the Run button none of the five 2020 projects are shown in the 2020 Projects Quarry after I close it and then open it.

1 Reply
Highlighted

@Larrym3525 

Use =2020 or, if the field is text, ='2020'