Problem with a function

[serino]

Hi,

I am having problems with the function below.

This part works fine.

Alias: IIf([T (107) Left4Digit of JobNum]![Left4]=[T (090) SubDivisionNum]![SubDivPrefix]),[T (107) Left4Digit of JobNum]![Left4), if false (they do not equal) I would like to continue with this

(IIf([T (107) Left4Digit of JobNum]![Left4]=[T (090) SubDivisionNum]![Alias1] Or [Alias2],304)))

 

[PHV]

Perhaps something like this ?
IIf([T (107) Left4Digit of JobNum]![Left4]=[T (090) SubDivisionNum]![SubDivPrefix],[T (107) Left4Digit of JobNum]![Left4]
,IIf([T (107) Left4Digit of JobNum]![Left4]=[T (090) SubDivisionNum]![Alias1] Or [T (107) Left4Digit of JobNum]![Left4]=[T (090) SubDivisionNum]![Alias2],304,0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[serino]

Thank You PHV, That worked out just fine..