Brother International WP1700MDS Owners Manual - English - Page 221

Selecting, Range

Page 221 highlights

FBI A".-rsor 1 .,e n-,I, - 3 Bennet 4 Carter 5 Fox 6 Higgins Higgins Jackson I Lee ,J Marsh ohn William William David Terry Joyce Ruth Howard Kevin Henry 1_ Freeport VT Westfield NJ Dallas TX Fremont CA Atlanta GA Cambridge MA Stanford CA Bedford TX Miamiburg OH UELLE 66622 28854 76021 94537 30341 11000 56904 76021 45342 PITCH: 1( You may use both alphabetic and numeric, ascending and descending sorts to organize the data. You may also use different primary and secondary keys (such as by city and first name) to put your data in the order most convenient to your purpose. Selecting Data From a Range The SELECT option in the SORT menu allows you to print rows of data that match a specified condition. However, you may only select numeric data. With the SALES template, for instance, you might wish to print a list of sales persons whose sales are lower than expected. In the example used previously, the only numeric data was the zip code, so we will use this data here. 1. Position the cursor on a corner of the range you want to select from, then press MENt1). The function menu appears: COLUMN FORMAT RECALC 'TORT CLEAR CONVERT 2. Select SORT and press This menu will appear: A N SORT ',LL [ SORT & SELECT 3. Choose SELECT and press . This message will appear: Mark range to select from. Press RETURN when done. 4. Move the cursor to the opposite corner of the range and press system will ask you to enter the name of the column to be used. . The This message will also appear; Enter the select column and press RETURN. 211

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316

FBI
1
A".-rsor
.e
,
n-,I
,
ohn
PITCH:
1_
UELLE
-
William
Freeport
VT
66622
3
Bennet
William
Westfield
NJ
28854
4
Carter
David
Dallas
TX
76021
5
Fox
Terry
Fremont
CA
94537
6
Higgins
Joyce
Atlanta
GA
30341
Higgins
Ruth
Cambridge
MA
11000
Jackson
Howard
Stanford
CA
56904
I
Lee
Kevin
Bedford
TX
76021
,J
Marsh
Henry
Miamiburg
OH
45342
1(
You
may
use
both
alphabetic
and
numeric,
ascending
and
descending
sorts
to
organize
the
data.
You
may
also
use
different
primary
and
secondary
keys
(such
as
by
city
and
first
name)
to
put
your
data
in
the
order
most
convenient
to
your
purpose.
Selecting
Data
From
a
Range
The
SELECT
option
in
the
SORT
menu
allows
you
to
print
rows
of
data
that
match
a
specified
condition.
However,
you
may
only
select
numeric
data.
With
the
SALES
template,
for
instance,
you
might
wish
to
print
a
list
of
sales
persons
whose
sales
are
lower
than
expected.
In
the
example
used
previously,
the
only
numeric
data
was
the
zip
code,
so
we
will
use
this
data
here.
1.
Position
the
cursor
on
a
corner
of
the
range
you
want
to
select
from,
then
press
MEN
t1).
The
function
menu
appears:
COLUMN
FORMAT
RECALC
'TORT
CLEAR
CONVERT
2.
Select
SORT
and
press
This
menu
will
appear:
A
N
SORT
',LL
[
SORT
&
SELECT
3.
Choose
SELECT
and
press
.
This
message
will
appear:
Mark
range
to
select
from.
Press
RETURN
when
done.
4.
Move
the
cursor
to
the
opposite
corner
of
the
range
and
press
system
will
ask
you
to
enter
the
name
of
the
column
to
be
used.
.
The
This
message
will
also
appear;
Enter
the
select
column
and
press
RETURN.
211