to cover multiple items with the same purchase date
Code: Select all
ORDER BY "Story"."date of purchase", "Products"."brand" ASC
or maybe
Code: Select all
ORDER BY "Story"."date of purchase", "Products"."unit price" ASC
or list most expensive items first
Code: Select all
ORDER BY "Story"."date of purchase" ASC, "Products"."unit price" DESC
Using non-printing characters in field names can come back to bite you. If you don't like run on names like "dateofpurchase" use "date_of_purchase" or "date-of-purchase". When writing queries, abbreviated names are easier to type like "upr" and "dop".
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11