Bob, The frequency field in the log is designed to be in the format it is in. All of the radio interface, and other conversions expect it that way. If you change it, you will get some really squirly results and probably destroy the useability of the database.
If you want something different on labels, cards, or designed reports, convert the field there. Regards, Jack ----- Original Message ----- From: "Bob Brunius" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, February 05, 2005 1:40 PM Subject: [Dxbase] Too many digits on the frequency part of the QSL label? FYI; I solved my own problem on the digits in the frequency print out for the QSO label. Using the following expression in the label designer converted my KHz DXbase records into MHz on the label. val(FREQ)/1000 Original Question: All along my auto-fill from the ICOM 765 has been filling the frequency field with KHz. That is a 160M freq shows something like 1893.13 and a 20M QSO is 14235.21. I have a lot of QSOs. So is there a way to automatically remove 3 orders of magnitude from the frequency field by doing a script? Perhaps directly in Access? Then the other question is how do I get my auto fill from the transceiver to fill in MHz and not KHz? ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected]
