Sorting

[Guest]

I am trying to sort a report using the Sort feature and the item I want to
sort on is not displayed in my dropdown list of choices yet it is in the SQL
and an text box on the report. Suggestions?

 

[Arvin Meyer [MVP]]

I am trying to sort a report using the Sort feature and the item I want to
sort on is not displayed in my dropdown list of choices yet it is in the
SQL
and an text box on the report. Suggestions?

In the report's design view, check the field list and make sure it is
listed. If it is, temporarily drag it to the report and make sure it has
data in it. If it isn't, recheck your report's recordsource.

 

[Guest]

The field [Item] is listed in the field listed. I dragged it to the report
and data was in it, however, it still did not display in the Sort/Grouping
options. I checked the recordsource as well and it is listed there.

 

[Arvin Meyer [MVP]]

That's strange. I'd be glad to take a look at your database if you compact
it, then zip it and email it to arvinm at accessmvp dot com. Send a separate
email telling me which report to look at.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

The field [Item] is listed in the field listed. I dragged it to the
report
and data was in it, however, it still did not display in the Sort/Grouping
options. I checked the recordsource as well and it is listed there.

In the report's design view, check the field list and make sure it is
listed. If it is, temporarily drag it to the report and make sure it has
data in it. If it isn't, recheck your report's recordsource.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com