Crystal Reports - Filtering Records

[system]

I am a beginner with Crystal and am re-writing my Report Builder Reports. I have a 2 questions for you Crystal Gurus...

Here goes:

Question 1:

How do you do an "or" with ranges in Select Expert?

Example:

(JobMtl.PartNum >= 100A
JobMtl.PartNum <= 199Z)
or
(JobMtl.PartNum >= 500A
JobMtl.PartNum <= 599Z)

Question 2:

How do you reference a field against another field in Select Expert?

Example:

Part.InteralUnitPrice <> Part.AvgPrice (calculated field)

Do you have to do this with a formula under the "Suppress" option for the detail line?

Thanks

Juliet