Search results

I would like to be helped to write a code in VBA that can sum Lowest 2 values in a query of 5 field values, and have this sum placed in a separate field "Low" for each row. qryLower2: ID ; Fa=1 ; Fb=2 ; Fc=3 ; Fd=4 ; Fe=5 ; Low=3 i.e Low=Fa + Fb

Hi I am an Access 2007 User. I do make Databases for Schools, Hospitals, Shops etc. but ofcourse I get stranded at times and I hope this Forum will be Helpfull.