ACC97: Can't Follow Hyperlinks in Totals QueryLast reviewed: April 1, 1997Article ID: Q164984 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When you create a totals query that uses the SQL aggregate functions First() or Last() on a Hyperlink field, the query results do not display a usable Hyperlink field. Instead you see the Displaytext, Address, and Subaddress portions of the hyperlink displayed as text.
RESOLUTIONIf you want to use a Hyperlink field in a totals query, append the query results to an existing table that contains a Hyperlink field. Then you can open the table directly or create a select query based on the table in order to view the results and still maintain the ability to follow the hyperlinks. The following example illustrates how to do this using the Suppliers table in the sample database Northwind.mdb.
MORE INFORMATIONWhen you create a totals query that uses the First() or Last() function on a Hyperlink field, Microsoft Access displays the text equivalent of the Hyperlink field. The text of the field consists of three sections separated by number signs (#): the Displaytext, the Address, and the Subaddress.
REFERENCESFor more information about the different parts of a Hyperlink field, search the Help Index for "hyperlinks, returning hyperlink information," or ask the Microsoft Access 97 Office Assistant.
|
Additional query words: internet intranet sum
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |