ACC: How to Duplicate Microsoft Excel Fill Down Functionality

Article translations Article translations
Article ID: 103192 - View products that this article applies to.
This article was previously published under Q103192
Moderate: Requires basic macro, coding, and interoperability skills.
Expand all | Collapse all

SUMMARY

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.

Properties

Article ID: 103192 - Last Review: January 18, 2007 - Revision: 2.1
APPLIES TO
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Keywords: 
kbhowto kbusage KB103192
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com