Results for:
Query

• Power Tip: Automate an update query

  2 May 2011

  Power Tipster Justin Farrell has posted a new Access tip on his blog, showing how to create and execute an update query by using a form and a small amount of Visual Basic for Applications (VBA) code. After following his tip, you'll be able to update a large number of records just by opening a form, typing...
• Streamline reporting on recurring data imports

  26 Apr 2011

  Do you often have to summarize large data sets that have been extracted from your corporate database? Access can be very helpful when you need to work with a huge stream of data. We've published a new article that shows you how to make the data easier to import, analyze, and summarize in reports, even...
• The Cartesian product: a feature, not a bug

  30 Nov 2009

  Today's guest blogger is Access MVP Garry Robinson, who offers up another gem from the Smart Access collection of articles at http://www.vb123.com/kb . In this article written by Peter Vogel, you will be given an overview about what it means to write queries where tables are not joined. This is a good...
• Running an Access Parameter Query from Excel

  23 Oct 2009

  Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly: An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the...
• Use a crosstab query to create monthly summary reports

  31 Aug 2009

  After you've built a few Access database applications, you inevitably come up against this problem: the arrangement of your data in tables is not the arrangement you want on reports. Frequently, values appear vertically in a table, but you want them to appear horizontally on the report. Luckily, crosstab...
• Create flexible Excel exports with on-the-fly SQL

  25 Aug 2009

  Kingsway Financial Assessments provides independent financial assessment reports and credit reports to support decision making when awarding contracts and tenders. Kingsway uses an Access database built by Hockley Computer Services using Goldsoft . Ken Hockley is today's guest blogger. I’ve been using...
• Put IIF statements in a table to use in a query

  11 Aug 2009

  Readers Trey Smith and Brandon Kessler from HealthTrans, LLC suggested the following Power Tip for streamlining Access queries. I ran into an issue at my job where I had so many IIF statements for a field in a query that the query wouldn’t run. We deal with many clients that all have different criteria...
• Set query parameters with macros

  5 Aug 2009

  Last week we blogged about changes to the new macro designer . I promised to write about IntelliSense but the first draft was lost in an unfortunate hard drive crash. I thought this is a good time to tell you about changes to the macro designer that encourage good design through better support of parameters...
• Create partition queries

  29 Jul 2009

  Raymond Starkey, Director of ACCESSible IT Ltd. , provided us with an example that he has used to teach Access users about using the Partition function to create a frequency distribution. As he says, “no one ever mentions these but they are so powerful they need a mention.” Note:Raymond’s example uses...
• Return a Limited Number of Rows on a Criteria Form

  16 Jul 2009

  Today’s guest blogger is Alison Balter. Alison is the founder of InfoTech Services Group, Inc. and has authored 14 Access books since 1995. When working in a client/server environment, it is imperative that you limit the number of rows that the user brings over the network wire. It is therefore necessary...
• Group numbers into custom ranges

  2 Jul 2009

  I was looking at SQM data about file size last week and ran into an interesting question. We capture the size of the file every time Access opens the file in SQM. It is interesting data as it provides insights into the size of a typical existing app. I wanted to bucket the ranges into something more...
• Dealing with the “ambiguous outer joins” message

  2 Jul 2009

  Today’s guest blogger is Colin Wilcox, writer for Access Training on Office Online. When you query multiple tables for data, you sometimes see a message about “ambiguous outer joins.” The message tells you to create a separate query that performs one of the joins, and then include that first query in...
• How to make TempVars work with OpenRecordset

  12 Jun 2009

  Recently Maarten a blog reader asks: TempVars (introduced with Access 2007) are great! But I have some problems in using them. I created a query with a TempVar as criteria. When I run the query it shows the correct data. But when I open the query in VBA using OpenRecordset, I get the message: “Run-time...
• New Access training courses on Office Online

  3 Jun 2009

  Access Training writer Colin Wilcox has just finished up a series of query courses, available for free on the Access 2007 training courses page on Office Online. Here’s the whole set: Find answers with queries Course What you'll learn Queries I: Get started with queries An overview of what queries are...
• Accessing external data using the IN clause

  27 Mar 2009

  Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword. The most commonly used case is as part of the WHERE clause of a SQL statement to provide...
• Data bars in an Access query

  18 Mar 2009

  Mike Alexander (Excel MVP) recently sent me a very cool trick that I hadn’t seen before. He uses some simple hackery and trickery to get data bars in a query. This is the first installment of a long series about how Access can be used to create cool dashboards. You can see more free training videos from...
• Previewing a Temporary SELECT Query

  14 Nov 2008

  Last night I was working on a database where I wanted to run a temporary query from a linked table that I had. The query was temporary because it's being used in a tool that I'll only run a handful of times. Nevertheless, the data from the query is going to end up in a production database, so I wanted...
• Code to make dates easier to read

  8 Feb 2008

  Today's author: Kerry Westphal, a program manager who works on the Access team. I like how many web 2.0 applications make it very easy to visualize complex data quickly. I found myself recently challenged with this task while working on a project where I wanted to display on a report an easy way to show...
• Teaching users to fish--an online intro to queries

  4 Dec 2007

  Does this sound familiar? Smart Access user builds a cool database to help co-workers do their jobs more efficiently. Co-workers sing praises and advocate a raise for the smart Access hero. A few weeks later, end users ask hero to help create a couple queries and reports to answer more complex business...
• Sorting Nav Pane Objects by Description

  3 Oct 2007

  I've recently had some questions from users who used to sort their DBC by the description field and wanted to be able to do the same thing in the 2007 navigation pane. If you use this scenario, and you've tried in 2007, you'll know that the navigation pane doesn't have a sort by the description field...