[IRCA] reformatting "Ham Radio Deluxe" log to submit to DXM

["Mary Anne Sanford" <ke7cgz@xxxxxxxx>]

If you are using "Ham Radio Deluxe" (http://hrd.ham-radio.ch/ ) for logging
you can format the log for output to DXM.  The application uses an access 97
database.  If you are familiar with Microsoft Access and have a copy of
access you can do the following.

This is a little on the quick-and-dirty side.

1) Make a new access database in a convenient place
2) Link the tables in your copy of the Ham Radio Deluxe Logbook .mdb to your
new database. keep the same table names.
3) Create a query and insert the following SQL into it. You can do this in
[view][sql]
4) Run the query and copy the column WDXRU into notepad to do a bit-o-final
reformatting
5) Paste final to your email to send to DXM editor of your choice.

You can modify the query to focus on foreign loggings to fit the needs of a
specific editor.

SELECT IIf(Len([frequency])>8,"1" &
Mid$([Frequency],3,3),Mid$([Frequency],2,3)) AS Freq, InStr(1,[QTH],",",1)
AS comma, Left$([qth],[comma]-1) AS City, Mid$([qth],[comma]+2,Len([qth]))
AS State, IIf([endtime]-[starttime]>0,Format([starttime]-(5/24),"mm/dd
hhnn") & "-" &
Format([endtime]-(5/24),"hhnn"),Format([starttime]-(5/24),"mm/dd hhnn")) AS
[Datetime], [freq] & "  " & [Station] & "  " & [State] & ", " & [City] & " "
& [datetime] & " " & [remark] & " SINPO" & [ReportRecv] & " (MAS-OR)" AS
WDXRU
FROM TBL_LOGBOOK
WHERE (((TBL_LOGBOOK.QTH) Is Not Null) AND
((TBL_LOGBOOK.StartTime)>=#12/24/2005#) AND ((TBL_LOGBOOK.Country)="USA" Or
(TBL_LOGBOOK.Country)="Canada"))
ORDER BY TBL_LOGBOOK.Frequency;

_______________________________________________
IRCA mailing list
IRCA@xxxxxxxxxxxxxxxx
http://arizona.hard-core-dx.com/mailman/listinfo/irca

Opinions expressed in messages on this mailing list are those of the original contributors and do not necessarily reflect the opinion of the IRCA, its editors, publishing staff, or officers

For more information: http://www.ircaonline.org

To Post a message: irca@xxxxxxxxxxxxxxxx