Crystal Reports Record Selection Help

Message

     Below is my Record Selection Formula:

({Table.Create Date} in LastFullMonth 

or

{Table.Closed Date} in LastFullMonth)

and

({Table.Location_A} = "mrs-moe"

or

{Table.Location_B} = "mrs-moe")

The above formula is returning records for Location_A only while my intention is for it to return records whenever the string "mrs-moe" is matched.

If I put only one of the last two statements alone I would get the records for that statement.

For example if my formula was like this:

{Table.Create Date} in LastFullMonth 

or

{Table.Closed Date} in LastFullMonth)

and

({Table.Location_A} = "mrs-moe")

I would get the records where Location_A = "mrs-moe"

Likewise if it was like this:

{Table.Create Date} in LastFullMonth 

or

{Table.Closed Date} in LastFullMonth)

and

({Table.Location_B} = "mrs-moe")

I would get the records where Location_B = "mrs-moe"

So nothing wrong with my database and I'm sure I'm missing something in my logic here!

How can I get both while also matching the date criteria?

Please Help!!

Thanks

- MO