Outlook

Can’t find that email message? These three tips can help.

(This post was first published in 2010.  It’s obvious from the number of hits this page gets that people’s inboxes are still overflowing. We thought we’d share it again to help you out.) Hi, I am Roby Kurian, Product Manager for Outlook. How often do you ask yourself, “Where’s that message?” Whether you are a filer (you keep messages carefully organized in folders) or a piler (you keep all of your…

Access

Using crosstab queries in reports

A well designed database stores data in a normalized format with dates defined in a field so that new data is simply added as additional records. However, people want to see data with dates grouped by columns. This can be done by using a crosstab query. However, when creating reports based on crosstab queries, we need to control the specific column names that are returned by the query. Otherwise, the report…

Access

Access 2010: How to write expressions for Web queries, forms, and reports

Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where…