Modifying Crosstab Query Heading based off parameters

Modifying Crosstab Query Heading based off parameters

...I have a table for intersections I am studying and each one has before
periods and after periods (B1 start, B1 end, A1 start, A1 end, etc). On
another table I am keeping track of all crashes that occur and they are
linked to intersections by a site number.
...I currently have a crosstab query that brings up the intersection
(rows) and totals of each "Crash Type" that occurs. It appears similar to
the following: ........................
...........RearEnd...HeadOn...LeftTurnHeadOn...etc
Site #
...I have figured out how to only count intersections during one range of
start end times (B1 start, B1 end) however I am curious if there is a way
to have the query count all ranges at the same time (B1, B2, A1, A2, etc)
and display them with the headings appropriately modified?
Example.................................... ........B1 RearEnd...B1 HeadOn
.... B2 RearEnd...B2 HeadOn .... A1 RearEnd etc.
Site #
Any help figuring this would be greatly appreciated. (Also sorry for the
strange formatting I've never done this before and tried to do what I
could to make it readable)