Order by

[mithani]

Hi all,

I have made one query based report. In my report I want data should be ordered by Expenses_Code_num. So simply I have mentioned Expenses_code_num in Order coloumn. When I run report, getting error. Please have a look attached jpg error.

Please advice me.

Mithani

 

[ajetrumpet]

This is very simple:

If there is an aggregate function in a query, any fields that are not part of that function must be included in a GROUP BY clause, as noted here:

http://www.access-programmers.co.uk/forums/showthread.php?t=135763

 

[mithani]

Thank you ajetrumpet

mithani