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:

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

propecia merck
1. Click Run.

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