Creating Crosstab Queries in Microsoft Access

Synopsis

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

Statistics

  • Total Hits - 37625

  • Total Votes - 114 votes

  • Vote Up - 51 votes

  • Vote Down - 63 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.

Source Website

Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.

http://www.databasedev.co.uk/crosstab_queries.html

Broken  |   Save  |   Liked  |   Down

Advertisements