>I need the records where reg_meeid is CAMEX2000 to CAMEX2004. Using Inlist will give me any records where at least one of the condition is true. How can I get where all of the condition is true?
>
>Thanks
IN a single record, the field reg_meeid can be equal to CAMEX2000, or it can be equal to CAMEX2001, but it can't be both at the same time.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)