ACC: How to Replicate MS Excel Fill Down Functionality

 Last reviewed: April 2, 1997
Article ID: Q103192
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

This article describes how to duplicate the Microsoft Excel FillDown method in Microsoft Access.

MORE INFORMATION

In Microsoft Access, you can use an update query to achieve fill down functionality. The following example creates a copy of the Orders table in the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0) before performing the fill down functionality to make every shipping charge $10.00.

  1. Open the sample database Northwind.mdb (or NWIND.MDB).

  2. Select the Orders table, and on the Edit menu, click Copy.

  3. On the Edit menu, click Paste. Type Orders1 for the new table name, and then click OK.

  4. Create a new query based on the Orders1 table.

  5. Drag the Freight field to the QBE grid.

  6. On the Query menu, click Update Query (or Update in Microsoft Access 7.0 or earlier).

  7. On the Update To line in the Freight column of the QBE grid, type $10.00, and then press the TAB key.

  8. On the Query menu, click Run. Microsoft Access informs you that 830 records will be updated (1078 in versions 1.x and 2.0). Click OK.

  9. Open the Orders1 table. Note that all the records have a Freight value of $10.00.

Keywords : kbusage QryMktbl
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.