min between two fields

  • Thread starter Thread starter blendes
  • Start date Start date
B

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])
 
thanks

Michel Walsh said:
iif( CPKMDVA < CpkMDVB, CPKMDVA, CpkMDVB)



Vanderghast, Access MVP


blendes said:
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])
Click to expand...
Click to expand...
 
Back
Top