Maybe anybody has an idea how to frame the WHERE command to select only certain columns from a table?
I am having a table SALES with kind of the following columns: 1. CustomerID 2. Jan 3. Feb 4. Mar .... 13. Dec 14. Total_2018 15. Total_2019 16. Total_2020 17. Total_2021 A new column (Total_...) will be added for each new year, so I can keep sales history for many years. Then I have a report that prints the total of the current year (e.g. Total_2021) with three more "Total-Columns" allowing comparisons on different years. As columns will be added each year the report should dynamically adapt and show totals for new years for selection as they appear. Now, how do I build the WHERE clause in the CHOOSE command that allows the user do select two different columns (of former years), but of course only from those that contain annual totals "Total_*"? CHOOSE vChoose FROM #COLUMNS IN SALES WHERE ???? CHKBOX 3 + TITLE "Select 3 previous years for comparison" + CAPTION "Annual Sales Volumes" + LINES 5 FORMATTED Thanks very much for your ideas Rolf Bullinger -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/d27f0282-c8e9-44db-a289-f68fb68eb553n%40googlegroups.com.
