I have a report, it links up with the SQL tables in it perfectly fine. I'm only throwing in "name" and "Company" but I want to select the records based on a selection formula. I want all records where ANY of the following fields are after a specific date....

 

Activedate1

Activedate2

Activedate3

Activedate4

Activedate5

Activedate6

Activedate7

 

I'm using a greater than symbol before the date and an OR inbetween each....now, when I test this it works great but ONLY for the first couple fields....if I make a record in the table that has Activedate1 equal to 5/5/07 (so that no one else will come up) then that record shows up in the report like it should. If I instead change that record so that Activedate5 or 6 or 7 is equal 5/5/07 then the record doesn't appear.

 

Thinking it might be the fields that were messed up I changed the order of them in the selection formula and yet they work. It seems like it checks the first part of my formula but not anything past the first couple.

 

Does that make sense? I guess the best way to ask this is how would one of you write  selection formula (in crystal 9) that checked to see if any of 7 fields were greater than a specific date?