Recent content by TenTwenty

Solution implemented Hi, Here is the best solution that we found. All my thanks to those who helped. :D Query #1 with the name: qryDistinctComptBestLifts SELECT Lifter.uidLifter, Lifter.LifterNumber AS LifterNumber, Lifter.Lastname AS Lastname, Lifter.Firstname AS Firstname...

Hi Pat, If you look at the thread starter and at the solution that I linked to, it was what MS proposed. The whole thing is that after nearly a week and a half of staring at variants of the same code I'm so confused that I don't know how to go about of implementing the solution. What should go...

I have a table with the following data. uidWeight MaxWeight Description 1 50 50Kg 2 60 60Kg 3 70 70Kg 4 80 80Kg 5 90 90Kg 6 100 100Kg 7 125 125Kg 8 130 130Kg+...

Hi Pat, I ran the code but found that the statements in the where clause is ignored like, (Meet.MeetDate) = DATE ()) , ((Lifter.StatusInTeam) < 1) If you change the Lifter.StatusInTeam you will see that the calculated rank is out of sync. I've uploaded a new database with more data to...

Hi, I wrote the query below and everything works fine except that the rank does not display correctly in the case of a tie. The calculated rank after the ties would not be correct due to this code in the query: (SELECT COUNT(*) + 1 FROM History H INNER JOIN Lifter L ON...