I would like to run the code below in Record Selection Formula of CR 8.5
However, I met a problem that missing of ). For my passed experience i wondered how to handle to use IN in CR 8.5.Thus, what can I do at the passed is create another table to store record for show and link to main table. This time I'm having a lot of IN statement. Thus, It was inflexible if create a lot of table for showing record.

Any experts here can guide me the better method to overcome my problem.



SQL Code:
  1. {Machine_Desc.Mac_Name} = 'ACONT'
  2. AND {Machine_Desc.Mac_Type} IN('Assembly Machine','Auto Foaming Machine','BLOCK CUTTER MACHINE')
  3. AND {Machine_Desc.Loc} IN('BLOCK A','BLOCK B')
  4. AND {Machine_Desc.Status} IN('ABSOLUTE CRITICAL')
  5. AND {Machine_Desc.Vendor} IN('Chang Yee','Chia Berhad ','Fides (Italy)')
  6. AND {Machine_Desc.Mac_Year} >= '1968' AND {Machine_Desc.Mac_Year} <= '2000'


Thanks for a million.