Mail us
Home » Posts tagged "criteria access query"

Tag Archives: criteria access query

Access Queries: Date Criteria May Not Always Work with MS Access Query

Learning about ms access query  is the key to a good database management system as it is the heart of any database application. There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors. One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it’s conventions. Take a look […]

Tags: , , , , , , , ,

Adding A Parameter In Access Query: Using A Union Query

Microsoft Access Macros

If you know anything about what a parameter query is then the only added benefit and knowledge you need is knowing what and how to build a union query and apply adding a parameter to the Access query. As a reminder a parameter is a prompt for the user to enter a value which is then passed (as a variable – varying value) into the query as it’s criteria. You can have more than one prompt but you can imagine […]

Tags: , , , , ,

Problems With Memo Fields When Running A Query In Access 2010

Microsoft Access Database

I recently wrote an EzineArticle about the Memo fields when running a query in Access and what has changed with the latest version (2010). It can affect criteria and causes sorting challenges and should be avoided if at all possible. But if you really need it, then read on and know your options… Creating Microsoft Access Queries – Why You Should Avoid The Memo Data Type In Access Queries I recently worked on a migration Access database project converting from […]

Tags: , , , , ,