Q

qryContactIDsPhones query, 368 qryContacts query, 191 qryContactsForMerge query, 144 qryNeedTimesheets query, 202

qryNorthwindAll query creating PivotCharts from, 22-25 creating PivotTables from, 19-21 creating plain datasheet report from, 11-19 as data source, 50, 51, 52 qryOrdersAndDetails query, 62, 63 qryThisWeeksTimesheets query, 202 queries, Access calculated fields, 370-371 complex, 352

creating Excel PivotCharts from, 415-426 creating PivotCharts from, 22-25 creating PivotTables from, 19-21 creating plain datasheet report from, 11-19 as data sources, 50, 51, 52 exporting to Excel, 415-416 formatting data in Excel worksheets, 62-69 ListQueryFields function, 495-497, 511,

513-514 make-table, 109, 201, 205, 348 qryContacts query, 191 qryNeedTimesheets query, 202 qryOrdersAndDetails query, 63 qrythisWeeksTimesheets query, 202 upsizing, 660-662

using as basis for exporting Access data to Excel, 191, 192

using to concatenate Access data for export, 143-144

QueryDef object, 104-106, 109, 113, 130 QueryDefs collection, 495, 522, 544

0 0

Post a comment