Creating Crosstab Queries in Microsoft Access

Tutorials Shared by the Internet Community

Advertisements


Synopsis

A Microsoft Access crosstab query presents summary information in a compact format that is similar to a spreadsheet.

Statistics

  • Total Hits - 23986

  • Total Votes - 113 votes

  • Vote Up - 51 votes

  • Vote Down - 62 votes

  • Domain - www.databasedev.co.uk

  • Category - MS Access/Query Languages

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:38:15

Description

A Microsoft Access crosstab query presents summary information in a compact format that is similar to a spreadsheet. These types of queries can present a large amount of summary data in a format that is usually simpler to analyse than viewing the information in a database form. Each attribute (field) in a table typically contains a category of data. A crosstab query summarizes the data from one or more of these fields that are separated into groups based on one or more fields. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements