I am still confused from the other thread that we took no where...
So let's take this slow - one step at a time.
Since you are in ACCESS (which I nevered used by the way - so it's difficult to even have this conversation...) - you have some kind of query builder screen - right? You can type a query in that screen and execute it to see the results - right?
Let's try this:
Since I think I understand your last post to say you want the minimum VALUE for a particular QUESTION+MODULE combination - then this should work.Code:Select Question,Module,Min(Value) From Table Group by Question,Module
Does it??




Reply With Quote