G
Guest
I have a table regarding tours that are given at our facility. The main
fields are Tour ID, Tour Date, Tour Guide, Host Organization, etc. All of
the tours are in CY05 and CY06. I need to create a pivot chart that compares
the CY05 with CY06 sum of tours by Host Organization and Tour Date. I have a
query that works fine if I just want CY05 and a query that works fine for
CY06 and a query that works fine for both years combined. However, I am not
able to figure out how to set up criteria in one query that will break apart
the CY05 and CY06 results so that I can make the pivot chart display the two
years side by side. Any help is appreciated.
fields are Tour ID, Tour Date, Tour Guide, Host Organization, etc. All of
the tours are in CY05 and CY06. I need to create a pivot chart that compares
the CY05 with CY06 sum of tours by Host Organization and Tour Date. I have a
query that works fine if I just want CY05 and a query that works fine for
CY06 and a query that works fine for both years combined. However, I am not
able to figure out how to set up criteria in one query that will break apart
the CY05 and CY06 results so that I can make the pivot chart display the two
years side by side. Any help is appreciated.