Creating Crosstab Queries in Microsoft Access
|Top Tutorials||New Tutorials||Submit||Login||Register|
Total Hits: 12186
Total Votes: 145 votes
Category: MS Access/Query Languages
Submitted on: 2008-04-15 07:38:15
Submitted By: Shekhar
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. More detail...