var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: selecting only records with unique key
This is more of an SQL problem then Access, but the database I am working with is an Access database.
Anyways, here is the situation:
Now I know how to find all the unique values for the field "Key", but I need to get the value with it. if i try SELECT DISTINCTROW, i just get all of those rows back.
it doesn't particularly matter which value1 i get with the key, i just need any copy of value1.
here is a sample result:
ANybody know how to do this? Thnx.
Here is one solution you can try:
SELECT DISTINCT Key, FIRST(Value1) AS ValueField
GROUP BY Key;
Also, you can change the value FIRST to:
Let me know if this helps
yep, that works perfectly... dang, how come i didn't think of the FIRST function... heh.