Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab Query with 2 Column Headings

Status
Not open for further replies.

randaj

MIS
Jan 7, 2003
34
US
Is this possible? The data is fairly simple, A(compound) and B(compound) equal X(Value). I would like to have a query/report that would have all the A's on the X axis and the B's on the Y's axis ALONG with sum, avg, and stdev.

Example:

| A | B |
|Sum Avg Stdev| Sum Avg Stdev|
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top