If I make a lookup table will this cause the Band value to appear in the Band window of the entry form after the frequency value has been added.
Sorry to ask these questions but I am an electrical engineer with an Que Access book in front of me.
Mark
OK I shall have to read up about lookup tables. I am a fumbling amateur with Access.
These are ham radio bands,so there are specific short wave frequencies and bands of operation. Yes there is no operation on 2.5 MHz for amateur stations.
A few more are 14.0 to 14.350 20M - 20...
I am exporting this database as an xls file and then in Excel I am manipulating the data and exporting it from Excel as a tab deliminated file in ADIF format and I think that I need a BAND entry in this format for use in LOTW (Logs of the World) - aren't you glad that you asked lol. So it seemed...
I have an MS database for my radio logs. I have a field named Frequency and a second field named Band. The value that is entered into Band is mathematically related to the frequency value. Here are some of the relationships. There are quite a few more
Frequency >1.8 or <2.0 then put 160M into...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.