I am a new Acces user and am having trouble with the Min function. I want to derive the minimum price from several supplier prices for the same item. Each supplier has a field and I want the Minimum from across 5 adjoining fields. I can use nested IIF expressions to do it but would like to use a Min Function. In excell I would use =Min(A5:F5) to get a Min. What do I do in Access.
To answer please click on Q or A sign on the left of the subject.
Written and designed by
Send us your comments
Copyright © 1998-2007 by MAUG