Search results

Hi all So I have two queries...both feeding from linked tables. They now both have the exact same columns in them. One is a table of "Placeholder Predictions"...so predictions all players have made prior to the game. The second table has all the "New Predictions"...all predictions made by all...

So I have searched everywhere and can find half of the answer but not the other half. :banghead: I have a table of predictions. For MatchID #1, PlayerID 56 predicted twice, so I need to take the latest prediction from them, but I also need everyone else's predictions. I have attached how it...

Hi I have my main form which is f_main. On there is a Subform called subfrmFront and that has a source object of the form f_front A button on f_main opens up a popup. In this popup, the fields I am updating all relate to the same records that are being displayed in the subform. Everything...

Hi guys. I am driving myself insane trying to write this and could really do with help. Basic outline is that players predict the attendance of a football game. We award 1 point if they guess within 500 of the attendance, 2 points if within 250, 3 points if within 100, 4 points if within 50...