ACC1x: Cannot Use First() and Last() Functions in a Report

ID: Q103190

The information in this article applies to:

SYMPTOMS

Microsoft Access returns a #ERROR message in your Report field when you use First() or Last() functions.


RESOLUTION

It may be possible to use DFirst() or DLast() domain aggregate functions to achieve the results you want. However, these functions ignore any sorting or grouping in your report. You may need to supply a criteria to these domain functions to return the data desired.


STATUS

This problem no longer occurs in Microsoft Access version 2.0.


MORE INFORMATION

Steps to Reproduce Problem


  1. Open the sample database NWIND.MDB.


  2. Open the Alphabetical List of Products report in Design view.


  3. Add an unbound text box to the Report Header section as follows: 
    
      Object: Text Box
      ----------------
      ControlName: First Product
      ControlSource: =First([Product Name])


  4. From the File menu, choose Print Preview. 
    
   The text box that you added, First Product, evaluates to #ERROR.



REFERENCES

Microsoft Access "Language Reference," versions 1.0 and 1.1, page 139

Additional query words: first last pounderror 


Keywords          : kbusage RptSort 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: March 26, 1999