Country name - Printable Version +- Swisslog's Forum (https://www.swisslogforwindows.com/forum) +-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3) +--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4) +--- Thread: Country name (/showthread.php?tid=994) |
Country name - HB9TZU - 24-05-2022 Good evening I have a column in my logbook view with the DXCC. However, only the acronym is displayed (e.g. I for Italy or HB9 for Switzerland). Is there a possibility to show the full country name instead of the short sign? Many thanks Christof HB9TZU RE: Country name - EA3GCV - 24-05-2022 Hello Christof, Of course is possible but you have to play a little bit with your query. In order to do this you have add the INF_DXCC table then link the DXCC field from the QSO table to the DXCC field in the INF_DXCC table, then add the DXCC_NAME from the INF_DXCC. You can see an example in View / Logbook view (select) then open any query from the DXCC folder then edit the query. Best 73 RE: Country name - HB9TZU - 24-05-2022 Good evening Jordi Thank you very much for your answer. I will try that tomorrow evening (now I am too tired... hi). 73 de HB9TZU Christof RE: Country name - HB9TZU - 25-05-2022 Good evening Jordi So, after a few attempts, the display looks the way I wanted it to. This seems to be a powerful tool. I think it's worth having a closer look. 73 de HB9TZU Christof RE: Country name - EA3GCV - 25-05-2022 Hi Christof, Queries are a very powerful tool! It's intended for advanced users but you can do a lot of things. There are many predefined Queries which will fit most user's needs. Some of them are very complex. The best way to investigate is to play a bit with a predefined query then save it with another name. And of course read the Power Query help! Best 73 |