Advance find formula

[Arun Rohila]

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]

--

[Steven L. Dasinger]

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]

[Arun Rohila]

That worked. Thank you

[Steven L. Dasinger]

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