Convert Layout of Query?

diofree

Registered User.
Local time
Today, 09:42
Joined
Nov 20, 2015
Messages
69
Hi guys,
I have a query running with the help of some helpful people on this forum, but it is not in the format my users want. Is it possible to change the layout to the way I have diagrammed?

Thanks!
 

Attachments

  • Capture2.PNG
    Capture2.PNG
    15 KB · Views: 126
Last edited:
yes, you want a CrossTab query.
use the query wizard and begin, select your existing query (top)
the wizard will ask you how to lay it out. (the bottom version)
 

Users who are viewing this thread

Back
Top Bottom