FIX: Domain Functions Available Only Within SQL Statement (102479)

   Set Dn = Db.CreateDynaset("Select DAvg(""AU_ID"", ""AUTHORS"")
      FROM Authors")

MORE INFORMATION

Step-by-Step Example

The following example demonstrates how to print to the form an average of all the AU_ID values in the Authors table from the BIBLIO.MDB database that comes with Microsoft Visual Basic version 3.0 for Windows:

1. Start Visual Basic or from the File menu, choose New Project if Visual Basic is already running. Form1 is created by default.
2. Add the following code to the Click event of Form1:

      Sub Form_Click()
         Dim Db As Database
         Dim Dn As Dynaset
   
         Set Db = OpenDatabase("C:\VB\BIBLIO.MDB")
         ' Note: enter the following Set Dn code as one, single line.
         Set Dn = Db.CreateDynaset("Select DAvg(""AU_ID"", ""AUTHORS"")
            FROM Authors")
            Print Dn(0) ' This is the equivelant of
                        ' Form1.Print Dn.Fields(0).Value
         ' It is always a good idea to close the database objects:
         Dn.Close
         Db.Close
   
      End Sub

3. Run the example. Then click the form.

All the other domain aggregate functions work in a similar way. It is only the example that is incorrect in the Visual Basic Help file. The other information explaining how to use the function parameters is correct.

The Following are the Domain Aggregate Functions: