Tagged Content List

Results for:
Queries

  • 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...

  • Power Tip: Exclude data from a query by using a table

    22 Jul 2010
    Today’s Power Tip comes from Bob Larson of BTAB Development . Bob is a former Access MVP (2008-2009, 2009-2010), and offers a host of tips and code snippets on his site. If you have a long list of items to exclude from a query, and you don’t want to type a big IN statement in the query to...

  • Power Tip Link: Delete records by using a delete query

    13 Jan 2010
    Today's guest author is Luke Chung, President and Founder of FMS, Inc. DELETE queries are a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table. Delete query option in query Design View...

  • 3 new articles available on MSDN

    5 Oct 2009
    MSDN writer Sal Ricciardi alerted us to the availability of 3 new articles on MSDN, two written by Luke Chung of FMS Inc. , and one co-written by Luke Chung and Dan Haught. Title Author(s) Performance Tips To Speed Up Your Access 2007 Database Luke Chung and Dan Haught Error Handling and Debugging Tips...

  • Use a Cartesian product to create a list of all dates

    17 Aug 2009
    Today's guest blogger is Access MVP Glenn Lloyd of Argee Services. Check out his Office help blog and Access Help and Tutorial Blog . In working with applications that require scheduling, I often find a need for a list of all calendar dates within a specified time frame. Using Cartesian Product makes...

  • A pair of tips for working with queries

    6 Aug 2009
    Today’s Power Tip comes from Brandon with OpenGate Software, offering Microsoft Access products for Access users of ever experience level, including UI Builder , Designer , and Dashboard Builder for Microsoft Access. Here are two tricks in Access to make SQL easier.  The background context is that...