1322
Index
queries, action
creating, 671–675
data-type errors, 676
definition, 133
key violations, 676
record-locked fields in multiuser environments, 676
running, 675–676
troubleshooting, 676
truncating text data, 676
types of, 671
updating records, 672–673
queries, fields
adding, 138–140, 156
aliases, specifying, 144–145
choosing, 134
displaying, 145–147
field lists, 159
field selector, 142
hiding, 145–147
inserting, 144
names, displaying, 136
rearranging, 142–143
removing, 144
resizing columns, 143
selecting, 142
selecting in the QBE grid, 142
updating, 158
queries, recordsets
definition, 131
displaying, 140–141
overview, 134–135
printing, 153
sort order precedence, 148
sorting, 147–149
queries, selection criteria
for Date fields, 151–152
definition, 149
for Numeric fields, 151–152
for Text fields, 150–151
for Yes/No fields, 151–152
queries, tables
adding, 136, 160
choosing, 134
creating, 134
limitations, 156–158
moving, 159
multiple, 153–157
names, viewing, 155–156QBE (Query by Example) grid, fields
adding, 156
aliases, specifying, 144–145
displaying, 145–147
hiding, 145–147
inserting, 144
removing, 144
selecting, 142
QBE pane, hiding/showing Total row, 654
Qtr property, 362
queries. See also QBE (Query by Example); SQL
(Structured Query Language).
absolute speed, 858–859
adding, 137
counting records, 642–644
creating, 10–11, 135–138
crosstab, 133
definition, 130
displaying selected data, 134
errors, 1176–1177
example, 11
field aliases, 649
filtering data, 889–895
forms, displaying selected data, 134
hiding result fields, 647
invalid names, 1177
join issues, 1177
modifying data, 134
for multiple tables, 153–157
overview, 10–11, 130–133
performing calculations, 134
renaming fields, 647–649
reports, displaying selected data, 134
saving, 138, 153
saving field selections, 646–649
select, 133
selection criteria, specifying, 134
sorting records, 134
specialized, 133
specifications, 1248
SQL Server conversions, 1234
SQL statements, displaying, 136
subqueries, 134
top(n) records, 133, 644–646
total, 133
types of, 133
uses for, 13452_475348-bindex.indd 132252_475348-bindex.indd 1322 4/1/10 2:02 PM4/1/10 2:02 PM