[Logic] "all bands and modes award" report
Ken "AB5A" Eckel
[email protected]
Tue, 3 Sep 2002 01:12:18 -0500
Hi all,
I am trying to modify the "all bands and modes award" report. What I am
trying to
do is track the DXCC Challenge award, which is the mixed total of all bands
160M thru 6M.
The following statement works but will not fit in the report expression box:
IIF(like("*a?F*",progress),1,0) + IIF(like("*b?F*",progress),1,0) +
IIF(like("*c?F*",progress),1,0) + IIF(like("*d?F*",progress),1,0) +
IIF(like("*e?F*",progress),1,0) + IIF(like("*f?F*",progress),1,0) +
IIF(like("*g?F*",progress),1,0) + IIF(like("*h?F*",progress),1,0) +
IIF(like("*i?F*",progress),1,0) + IIF(like("*j?F*",progress),1,0)
What this does is SUM all the bands 160M through 6M. Do you know a way to
write this which is
more condensed? I do not know the variables or the "like" command. Is
there a way to write a loop
for values (a) through (j)? If there is I will modify all the entries to
calculate DXCC challenge award
counts to the right of the DXCC mixed totals. I plan to only print this new
stuff for tag = DXCC.
Thanks,
Ken Eckel, AB5A