Software

Use Access Query Totals to obtain a list of your customers' recent activity

When you need to round up data on when your customers last placed an order, an Access query can do the trick. Here's a quick walk-through that shows you how.

Orders have fallen in the last month and you are wondering whether you should send out another promotion. You decide to send one promotion to customers who have ordered recently and another to those customers whose last order was more than a month ago. Customers who haven't ordered in six months will be excluded from the mailing. To find out when each customer placed their last order, follow these steps:

  1. In the Database window, under Objects, click Queries and then click the New button. Click Design View and then click OK. (In Word 2007, click the Create tab and then click Query Design in the Other group.)
  2. Double-click the Orders table.
  3. Double-click the CustomerID, CompanyName, and OrderDate fields from the field lists (Figure A).

Figure A

  1. Right-click the Query grid and select Totals (Figure B).

Figure B

  1. Click the drop-down arrow of the Totals cell under the OrderDate field and select Last (Figure C).

Figure C

  1. Click Run.

The query Datasheet view lists each customer's name and last order date.


Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks