Solved

display the data in tbl1 differently- like tbl2

Posted on 2013-06-14
2
367 Views
Last Modified: 2013-06-14
hello -
attached sample db-
I have tables like tbl1-

need to display data like in tbl2-
Is there a way to query tbl1 to do this?
thank you
Test-103.accdb
0
Comment
Question by:davetough
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39248432
You can use Crosstab query, but there is one problem: column names will be ordered alphabetically. You should add numbers before column name. Look at sample
Test-103.accdb
0
 

Author Comment

by:davetough
ID: 39248732
great thanks-
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question