I am trying to create a report that sorts a sum of several fields from the query. The equation from the query is as follows:
"Table1"."PS #1" + "Table1"."PS #2" + "Table1"."PS #3"
When I create a report through the Wizard and ask it to sort this equation ascending, it doesn't import any of the data into the report.
Please help!!!
Sort Function in Database Reports
Sort Function in Database Reports
Openoffice 3.4.1 on MAC 10.7.4
Re: Sort Function in Database Reports
Do all sorting in the query.
And use an alias name for the calculated field.
SELECT *, "Table1"."PS #1" + "Table1"."PS #2" + "Table1"."PS #3" AS "Sum" FROM "Table1" ORDER BY "Sum" ASC
And use an alias name for the calculated field.
SELECT *, "Table1"."PS #1" + "Table1"."PS #2" + "Table1"."PS #3" AS "Sum" FROM "Table1" ORDER BY "Sum" ASC
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Sort Function in Database Reports
When I put this formula into the field in a query, it comes up with an error that the column is unknown. What am I missing?
Thanks!
Thanks!
Openoffice 3.4.1 on MAC 10.7.4