ACC2000: You Cannot Follow Hyperlinks in Totals Query (197373)

RESOLUTION

If 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 to view the results, and you'll be able to follow the hyperlinks.

The following example uses the Suppliers table in the sample database Northwind.mdb to illustrate how to do this:

1. Open the sample database Northwind.mdb.
2. Create the following table named Suppliers2 in Design view:

      Table: Suppliers2
      -----------------------
      Field Name: Region
         Data Type: Text
      Field Name: HomePage
         Data Type: Hyperlink
   					

3. Save the Suppliers2 table and close it. You do not need to create a primary key.
4. Create the following new query in Design view based on the Suppliers table:

      Query: HomePageQuery
      --------------------
      Type: Select Query
   
      Field: Region
         Table: Suppliers
      Field: HomePage
         Table: Suppliers
   					

5. On the View menu, click Totals to create a totals query.
6. In the QBE grid, select Group By in the Total row for the Region column; select First in the Total row for the HomePage column.
7. On the Query menu, click Run. Note that the FirstOfHomePage column does not contain usable hyperlinks.
8. On the View menu, click Design View.
9. On the Query menu, click Append Query.
10. In the Append dialog box, select Suppliers2 in the Table Name box, and then click OK.
11. In the QBE grid, select Region in the Append To row of the Region column; select HomePage in the Append To row of the HomePage column.
12. On the Query menu, click Run. Click Yes when prompted if you want to append the selected rows.
13. Close the query without saving it, and open the Suppliers2 table in Datasheet view. Note that the table contains the results of your query, including usable hyperlinks.