Index_Q

Q

qapp tag (query, append), 291, 304, 308

qddl tag (query, data definition), 291

qdel tag (query, delete), 291

qdf tag (querydef), 293

qflt tag (query, form filter), 291

qlkp tag (query, lookup), 291

qmak tag (query, make-table), 291, 304

qmakContactsConcatenated variable, 145

qmax function, 130

qmin function, 130

qry tag (query, any type), 291

qryConcatenateAddressComponents select query, 125, 335

qryConcatenateNameComponents select query, 125

qryContactsAlpha variable, 86

qryFilteredContacts variable, 237

qryOrders variable, 134

qrySplitAddressComponents select query, 125

qrySplitNameComponents select query, 126–127, 335

qsel tag (query, select), 291

qspt tag (query, SQL pass-through), 291

qsum function, 130

queries

action

append, 136–139, 338

delete, 146–147

make-table, 145

update, 139–143

boilerplate query expressions, 335

CreateAndTestQuery function, 237

crosstab, 132–135

data source, 156–157

frmExportToWordDatasheet, 399

frmExportToWordListBox, 381

joining, 307

nested, 152

New Query dialog box, 134

non-updatable, 147

renaming, 298–299

reports, 177

select

expressions, 122–125

overview, 121–122

qryConcatenateAddressComponents, 125, 335

qryConcatenateNameComponents, 125

qrySplitAddressComponents, 125, 335

qrySplitNameComponents, 126–127

selecting, 289

SQL-specific

ALTER TABLE statement, 150

CREATE INDEX statement, 151

CREATE TABLE statement, 150

data-definition, 19

DROP statement, 151

subqueries, 151–153

union, 147–149

tags, 291–293, 304, 308

tblMailMergeList, 391

totals

aggregate functions, 127–128

Count function, 130

Group By function, 132

Max function, 131

Min function, 131

Sum function, 129

txtLetterText, 402–403

union, 303

Queries to Rename dialog box, 299

Query Design toolbar

discussed, 333

Run button, 143

query grids, forms, 65

Query Properties property, 58

query/table row source, comboboxes, 85–86

quni tag (query, union), 292

qupd tag (query, update), 292

qupdSales object, LNC naming element, 294

qxtb tag (query, crosstab), 291