min between two fields

[blendes]

i am working on helping a co worker. She has a querie the is returning two
values. I need to find the minamum value between the two. My expression looks
like this: Min([CPKMDVA] Or [CpkMDVB])

 

[Michel Walsh]

iif( CPKMDVA < CpkMDVB, CPKMDVA, CpkMDVB)



Vanderghast, Access MVP

 

[blendes]

thanks

iif( CPKMDVA < CpkMDVB, CPKMDVA, CpkMDVB)



Vanderghast, Access MVP

i am working on helping a co worker. She has a querie the is returning two
values. I need to find the minamum value between the two. My expression
looks
like this: Min([CPKMDVA] Or [CpkMDVB])