J
john.bartlett
I received some generous help from the users of this group to get this
far. This works great for me.
UPDATE tblMain
SET tblMain.PrizeAssigned = 1
WHERE (((tblMain.Weight1)=(SELECT Max(Weight1)
FROM tblMain
WHERE tblMain.PrizeAssigned = 0)));
I thought I was done, but I ran into one more issue I haven't been
able to resolve. How do I deal with duplicate Max(Weight1) values
(i.e. A tie!) being selected. I can only have one winner.
I thought it would be pretty straight forward since I have another
sorting element avialable in the table. It is tblMain.Time (a unique
time of completion for each participant), but I can't get it to work.
Any ideas on how I can add this next sorting element (tblMain.Time)to
this existing code? I tried several approaches but I am really
struggling with the SubQuery syntax.
As always, thanks.
far. This works great for me.
UPDATE tblMain
SET tblMain.PrizeAssigned = 1
WHERE (((tblMain.Weight1)=(SELECT Max(Weight1)
FROM tblMain
WHERE tblMain.PrizeAssigned = 0)));
I thought I was done, but I ran into one more issue I haven't been
able to resolve. How do I deal with duplicate Max(Weight1) values
(i.e. A tie!) being selected. I can only have one winner.
I thought it would be pretty straight forward since I have another
sorting element avialable in the table. It is tblMain.Time (a unique
time of completion for each participant), but I can't get it to work.
Any ideas on how I can add this next sorting element (tblMain.Time)to
this existing code? I tried several approaches but I am really
struggling with the SubQuery syntax.
As always, thanks.