Arun Rohila Posted July 16, 2021 Share Posted July 16, 2021 Hopefully there's a better formula than I have. I have a saved search to find any comic with the Condition being a CGC. However, I can only do one for each CGC level, like 9 to 8 and 7 to 5, etc. I would like a formula that would find all of the comics that I have in stock that are either CGC or CBCS regardless of grade (9.8 - 7.5 for example). Here is the current formula that I have in the Advanced Formula to find only the CGC 9.8 to 9.0. Any help would be greatly appreciated. Items where: (I.[Condition] = "CGC 9.0" OR I.[Condition] = "CGC 9.2" OR I.[Condition] = "CGC 9.4" OR I.[Condition] = "CGC 9.6" OR I.[Condition] = "CGC 9.8" ) and I.[QtyInStock] > 0 Order by: I.[Title] -- Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted July 16, 2021 Share Posted July 16, 2021 Try this: Where: (I.[Condition] LIKE 'CGC%' OR I.[Condition] LIKE 'CGC%'LIKE 'CBCS%') AND I.[QtyInStock] >= 1 Order By: I.[Title], I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing] 1 Link to comment Share on other sites More sharing options...
Arun Rohila Posted August 4, 2021 Author Share Posted August 4, 2021 That worked. Thank you Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted August 4, 2021 Share Posted August 4, 2021 For Ranges, use BETWEEN. For example for CGC 9.8 to CGC 9.0: I.[Condition] BETWEEN 'CGC 9.0' AND 'CGC 9.8' AND I.[QtyInStock] >= 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now