+- 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