Crosstab query question

[Euler]

I want to create a crosstab query where I can get an average for a select number of row entries. In other words, let's say I have a database with three fields: days of the week, company name, hours worked. The row heading would be the days of the week, the column heading would be the company name and the values would be average hours worked. Now, let's say I just want the average for the group of Tuesday, Thursday and Friday instead of individual averages for each day. Is there a way to do this? Thank you.

[Welshgasman]

It is called a dynamic crosstab query.
https://www.google.com/search?q=dyna...obile&ie=UTF-8

[Euler]

I don't see how a dynamic crosstab query solves my problem.

[Welshgasman]

Now crossposted at https://www.access-programmers.co.uk...estion.325240/

[xps35]

Is this what you mean?

TRANSFORM Avg(YourTable.HoursWorked) AS AvgHoursWorked SELECT YourTable.DayOfWeek
FROM YourTable
WHERE (((YourTable.DayOfWeek)="Tuesday" Or (YourTable.DayOfWeek)="Thursday" Or (YourTable.DayOfWeek)="Friday"))
GROUP BY YourTable.DayOfWeek
PIVOT YourTable.CompanyName;

[xps35]

Now crossposted at https://www.access-programmers.co.uk...estion.325240/

While I was posting my answer

[Euler]

No, this isn't what I mean because the three days are listed separately in the results. I want the results to show the aggregation in one row for those three days only. Nice try, though.

[Minty]

Perhaps in order to enlighten us all as to what you really want, you could mock something up, as the answers provided to you so far (on both forums!), are giving you what you described you wanted in words, but apparently not what you really want in your head.
A cross tab is quite specific in it's required elements, and possible layouts.

So a picture paints a thousand stories. Get painting please.