Conditional category

[mohebk]

Hi,
I have a large file and trying to categorize the data in a certain column. I think there is a way that I used long time ago that you can, in a query, put a value in a new field called CAT1 if the value of the evaluted field falls between 1 and 4. Can you pleas help refresh my memory?

Thanks

Mo

 

[Remou]

Do you mean:

Cat1: IIf([ThisField]>1 And [ThisField]<4,"Matches","No Match")