The Basics of Databases by Viji Kumar

Author:Viji Kumar [Kumar, Viji]
Language: eng
Format: azw3
Published: 2017-10-23T04:00:00+00:00

The tallies and the league status are deduced (using the IF, THEN, ELSE instruction)

In this exercise, scores are only produced for games that have a status of complete scoring data. Games flagged as incomplete or as having no data are given a league status [0] specifying that there is no result available for the purposes of generating the league table and assigned zero tallies even if there are goals recorded for the game. The instructions are shown below.

tally one: IIf([league game]![status]<>"complete scoring data",0,Int(Nz([league tally one]![tally one])))

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.