My query is in this format:
Airport_Date_Rained?_Snowed?_Sunny?_Fair?_Haze?_Humid?
LAX_9/17/06_YES_NO_YES_YES_NO_YES
FLA_10/12/06_NO_NO_YES_NO_YES_YES
SUN_11/22/06_YES_NO_NO_YES_NO_NO
For many records, any number of airports and dates, but only yes/no responses. How do I create a report which gives the percentage of total Yes/Nos in each field per airport, but only has two fields on each section, something like:
Airport_Rained?_Snowed?
LAX_54%_12%
FLA_58%_2%
SUN_33%_41%
Airport_Sunny?_Fair?
LAX_64%_32%
FLA_68%_40%
SUN_63%_21%
Airport_Haze?_Humid?
LAX_42%_78%
FLA_35%_84%
SUN_46%_18%
I've been able to write a report that puts the percent of total yes/no per airport, but all of the fields had to be on one line. What should I do to obtain the design above?
(Note: the fields are not mutually exclusive, e.g. you can have rain and snow on the same day. The YES/NO data is produced by formulas in a query, the table only contains numerical data that the query interprets. I'd really prefer not to rewrite the table and query, however primitive they may be by access programmer standards.)
Airport_Date_Rained?_Snowed?_Sunny?_Fair?_Haze?_Humid?
LAX_9/17/06_YES_NO_YES_YES_NO_YES
FLA_10/12/06_NO_NO_YES_NO_YES_YES
SUN_11/22/06_YES_NO_NO_YES_NO_NO
For many records, any number of airports and dates, but only yes/no responses. How do I create a report which gives the percentage of total Yes/Nos in each field per airport, but only has two fields on each section, something like:
Airport_Rained?_Snowed?
LAX_54%_12%
FLA_58%_2%
SUN_33%_41%
Airport_Sunny?_Fair?
LAX_64%_32%
FLA_68%_40%
SUN_63%_21%
Airport_Haze?_Humid?
LAX_42%_78%
FLA_35%_84%
SUN_46%_18%
I've been able to write a report that puts the percent of total yes/no per airport, but all of the fields had to be on one line. What should I do to obtain the design above?
(Note: the fields are not mutually exclusive, e.g. you can have rain and snow on the same day. The YES/NO data is produced by formulas in a query, the table only contains numerical data that the query interprets. I'd really prefer not to rewrite the table and query, however primitive they may be by access programmer standards.)
