C
ctfrigg71
Hi!
I need to create a query that seems a little more complex than what I have
done before. I would greatly appreciate any advice on how I can accomplish
the following.
I have airline invoice detail that I need to compute the compliance % of
travelers booking air travel at least 14 days in advance. This field contains
a number. There is also a field that states whether the transaction is
"Over14" or "Less14".
I have previously done this calculation in Excel . I used a pivot table and
created a calculated item using the Count of "Over14"/Total Count of the
Over14 & Less14 for the value; Invoice Quarter as the column heading & a
manager's name (or country) as the row heading. I now need to do this in
Access as there is too much data and I need to be able to provide trending
information by traveler and manager.
Q1 2008 Q2 2008 Q3 2008
Manager1 75% 72% 73%
Manager2 65% 69% 70%
Table fields: Manager, Country, Days Advance Purchase (contains "Over14" or
"Less14"), Net Ticket Amt, Invoice Qtr ("Q1 2008", "Q2 2008", "Q3 2008", "Q4
2008") and some others.
What is the best way to do this??
Thank you so much for the help!
I need to create a query that seems a little more complex than what I have
done before. I would greatly appreciate any advice on how I can accomplish
the following.
I have airline invoice detail that I need to compute the compliance % of
travelers booking air travel at least 14 days in advance. This field contains
a number. There is also a field that states whether the transaction is
"Over14" or "Less14".
I have previously done this calculation in Excel . I used a pivot table and
created a calculated item using the Count of "Over14"/Total Count of the
Over14 & Less14 for the value; Invoice Quarter as the column heading & a
manager's name (or country) as the row heading. I now need to do this in
Access as there is too much data and I need to be able to provide trending
information by traveler and manager.
Q1 2008 Q2 2008 Q3 2008
Manager1 75% 72% 73%
Manager2 65% 69% 70%
Table fields: Manager, Country, Days Advance Purchase (contains "Over14" or
"Less14"), Net Ticket Amt, Invoice Qtr ("Q1 2008", "Q2 2008", "Q3 2008", "Q4
2008") and some others.
What is the best way to do this??
Thank you so much for the help!