Totals (group b)y + Update query?

[acenumber5]

I have a productvariant table that contains data like this:
ProductID, SKU, field1, field2, etc
1,1234,red, small
1,1235,red, large
1,1236,red,X-large
2,1237,blue,small
2,1238,blue,medium.

So I have 1 productID with multiple Variants (different sizes)

I'm trying to update a field for just one variant for each product ID. I don't care which one it is. I just need to make one of them the default variant by putting a "1" in one of the fields and "0" in the non default variant fields. I tried to do use the Group By function in the totals query, which will give me the out put I'm looking for:
1,
2,
3, etc

But I can't do an update query from that query.

I know I'm going about this the wrong way. Can anyone point me in the right direction? I'm using Access 2010.
Thanks!

[June7]

I don't understand. The variant fields have text values of blue, red, small, medium, large. What field do you want to update to 1 or 0? How will that produce output of
1,
2,
3,
etc?

[acenumber5]

Thanks for the replay. Sorry, My eyes were crossed when I wrote this. The actual field I'm trying to update is the DefaultVariant field. So most Items have 3 variants -Small, Medium, Large, and I have to have one of them be the default and the rest not default. So what I really need is:
ProductID1, Sku1, Defaultvariant= 1
ProductID1,Sku2, Defaultvariant = 0
ProductID1, SKu3, DefaultVariant =0

Right now its:
ProductID1, Sku1, Defaultvariant= 0
ProductID1,Sku2, Defaultvariant = 0
ProductID1, SKu3, DefaultVariant =0

Thanks!

[June7]

So the fields are: ProductID, SKU, field1, field2, DefaultVariant

DefaultVariant is a text, number, or Yes/No type?

Each ProductID will have several records. You want the record with lowest SKU to be set with DefaultVariant 1 and the others are 0?

If DefaultVariant is Yes/No field, try:
UPDATE Table1 SET Table1.DefaultVariant = IIf([SKU]=DMin("SKU","Table1","ProductID='" & [ProductID] & "'"),-1,0);

Otherwise, try:
UPDATE Table1 SET Table1.DefaultVariant = IIf([SKU]=DMin("SKU","Table1","ProductID='" & [ProductID] & "'"),1,0);

[acenumber5]

The DefaultVariat is a number field. 1 or 0.

I'll try your second suggestion. Thank you very very very much!