Results for:
expressions

• Query Criteria, Part 1: Be specific!

  27 Jun 2012

  ( This post was first published in August 2011 and is the first in a series of posts about using query criteria, which includes Query Criteria Part 2: Like what? and Query Criteria Part 3: prompting for input by using a parameter .) Queries are a fundamental part of developing and using any database...
• Access 2010: How to write expressions for Web queries, forms, and reports

  19 Mar 2012

  Today’s guest author is Russell Sinclair , the Program Manager for expressions, ACE, along with other features. (NOTE: Because this post explains one of the basic improvements to Access 2010, it remains very popular among Access developers. For that reason, we're republishing it so many more of...
• Date functions part 1: some common scenarios

  15 Sep 2011

  This is the first of a series of posts about date functions. Many of you search Office.com for help using date functions in Access. Perhaps you want to select some portion of a date (e.g., the year). Maybe you want to format the display of date/time data, or find the difference between dates. In this...
• Query Criteria Part 2: Like what?

  18 Aug 2011

  In part 1 of this series , we considered a basic example of using criteria in a query to make the query's question more specific. That's great if you know exactly what you're looking for. But what if you want to see inexact matches - say, everyone whose last name starts with Th ? You're in luck - Access...