Report won't sort!

[adamdunko]

My issue is as follows:

I have a simple report based on a query of 2 associated tables. There are 5 fields, Doc#, IssueDate, Title, Author, Remarks. All fields come from one table, with the exception of Title. These fields are being reported in a straight line under detail of the report. When I choose sortign & grouping, for some reason it is only allowing me to sort the report by IssueDate, Author, and Remarks. I need it to sort by Doc#. I cannot figue out why it is not allowing me to sort this simple report by the other fields.

Any help woul dbe appreciated.

 

[mp9]

What data type is the Doc# field?

http://www22.brinkster.com/accessory/

 

[adamdunko]

It is actually a hyperlink (text) field.

 

[mp9]

Access won't let you group or sort on a Hyperlink type field, sorry.

To get round this problem, modify your query to include a version of the hyperlink field that's converted to a string. You also need to allow for null values, hence the Nz function. anyway, you can then sort/group on this converted string instead. here's an exampel query:

SELECT [Doc#], [IssueDate], [Title], [Author], [Remarks], CStr(Nz([Doc#],"")) AS TextDocNum
FROM......

You can then sort/group on TextDocNum - for best results, you might want to add TextDocNum to your report but hide it, then show Doc# so you get the hyperlink formatting.

Hope this helps.

http://www22.brinkster.com/accessory/