Dmin function accross multiple columns

[hgus393]

Hi all,
Have a tough one for you all. I need to find the minimum value across a number of columns. But I don really know how to do this. I have checked the Dmin function but I cannot get this to work. I basically have a database where an entry is sorted by number, date anc accumulated value. The accumulated values are across several columns ie 49 columns to be exact. What I need to find is where in the interval ie from Column 1 to 49 which has the minimum value. Does anyone have a clue how to do this?

Bob

 

[Ron_dK]

Column 1 to 49 ? Sounds to me that your Dbase is not normalized.
Anyway, maybe this might help :
http://www.access-programmers.co.uk/forums/showthread.php?t=170280&highlight=dmin+fields
post #5.