if you have data in a table - you can use DMin() function
Ken wrote 13/04/2006 :
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 exp
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