D
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
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