Newby - Help
Things have changed quite a bit since using SQL in Unix many years ago. I am sure this is simple but need to find a start point. Trying to learn this software by setting up something familiar. Not getting results and getting frustrated. Tried a lot of different parts of the software from running a script on a button to doing a field calculation. Not working. PLEASE just get me started.
Game 1; Game 2 Game 3; Games Week
If Game 1 > 0 set Games Week to Games Week + 1 otherwise leave the Games Week the same
If Game 2 > 0 set Games Week to Games Week + 1 otherwise leave the Games Weeks the same
If Game 3 > 0 set Games Week to Games Week + 1 otherwise leave the Games Week the same
Will be the same with Week Pins and Total Pins etc. If someone can just get me started with the right syntax and where to put it I would much appreciate it.