Facebook Twitter

Microsoft Access Flaws - Grouping by Memo field yields garbage. Flaws in Microsoft Access Provided by Allen Browne, July 2007, based on a posting by Peter Miller.

Microsoft Access Flaws - Grouping by Memo field yields garbage

This article describes a bug in Access 2000 and later (JET 4 and later), where a memo field is displays incorrect characters under these conditions: You GROUP BY a memo field. MS Access: Data Definition Query. Microsoft Access 97/2000 can utilize Data Definition SQL.

MS Access: Data Definition Query

The process is a bit convoluted but it does work. Access has the limitation that you can only create one table per Data-Definition Query. I recommend using an external text editor to inhibit MS Access' love for parenthesis and other odd characters. Then copy and paste your pure SQL code directly into the Access SQL Query window. My recommended text editor is the shareware product TextPad. Create a hyperlink - Access - Microsoft Office Online.

When you create a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet.

Create a hyperlink - Access - Microsoft Office Online

Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) by using any of the following methods, Microsoft Access creates a label control (label: A control that displays descriptive text, such as a title, a caption, or instructions, on a form or report. Labels may or may not be attached to another control.) on the form or report. Tip In Access 2010, in addition to adding hyperlinks, you can also add live web content to a form.

Sample Relational Database Data Models. Access Tips: Query and Filter Criteria. When constructing a query or a filter, you need to tell Access what to look for in each field.

Access Tips: Query and Filter Criteria

You do this by defining criteria - typing something (an "expression") into the Criteria cell of the query or filter grid. If you do not define any criteria for a particular field, Access assumes that you are applying no constraints and will display everything it has. This means that you only have to define criteria for those fields you are interested in. Geekgirl's Plain-English computer tutorials.