Hi
Can anyone recommend an basic SQL tutorial that uses plain English? So far I've only found stuff that may as well be written in Martian!
All I want to do initially is understand how I can present a total of three fields on my list page. They are numbers (up to 3 figures only) and I want to enter them on the add page but also show a total in the list.
At present I've got as far as adding this to my SQL query list
[PredSwim],
[PredBike],
[PredRun],
PredSwim+PredBike+PredRun as Total,
but that just gives me the numbers in sequence. I'm pretty sure I need a SUM command in there but I'll be damned if I can make sense of it
Regards
Bob