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 Rhinorhino 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
Joined
Jan 7, 2003
Messages
34
Location
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