Sorting Problem

[DS]

I have snaking columns and I'm tring to sort a mix of Numbers and Alpha.
This works in a Query but when I put it in the report it does not sort with
any sense. Also on the report Sorting and Grouping the first sort level is
=1.

SELECT tblChartOfAccounts.ChartName, tblChartOfAccounts.ChartNumber
FROM tblChartOfAccounts
ORDER BY Val([tblChartOfAccounts].[ChartName]),
tblChartOfAccounts.ChartName;

What takes precedent, the query or the sorting and grouping on the report.

Thanks
DS

 

[fredg]

I have snaking columns and I'm tring to sort a mix of Numbers and Alpha.
This works in a Query but when I put it in the report it does not sort with
any sense. Also on the report Sorting and Grouping the first sort level is
=1.

SELECT tblChartOfAccounts.ChartName, tblChartOfAccounts.ChartNumber
FROM tblChartOfAccounts
ORDER BY Val([tblChartOfAccounts].[ChartName]),
tblChartOfAccounts.ChartName;

What takes precedent, the query or the sorting and grouping on the report.

Thanks
DS

The sorting in the query is irrelevant.
The Report Sorting and Grouping is where you should sort the report.

In the Sorting and Grouping dialog set
Val([ChartName]) Ascending
[ChartName] Ascending

 

[DS]

I have snaking columns and I'm tring to sort a mix of Numbers and Alpha.
This works in a Query but when I put it in the report it does not sort with
any sense. Also on the report Sorting and Grouping the first sort level is
=1.

SELECT tblChartOfAccounts.ChartName, tblChartOfAccounts.ChartNumber
FROM tblChartOfAccounts
ORDER BY Val([tblChartOfAccounts].[ChartName]),
tblChartOfAccounts.ChartName;

What takes precedent, the query or the sorting and grouping on the report.

Thanks
DS

The sorting in the query is irrelevant.
The Report Sorting and Grouping is where you should sort the report.

In the Sorting and Grouping dialog set
Val([ChartName]) Ascending
[ChartName] Ascending

Thanks,
That works. So now I have to go back and redo all of my reports!
DS