List data from another field if criteria are met

T

T-bird

On my reoprt if a client purchase a ticket 21 days in advance I need to know
what the ticket amount is. All data is located on the same table however the
report is grouped by division, A division could have 6 purchase with 3
differnt purchase times two of each. I need the Ticket Amount to be listed in
its appropriate column. I have 3 columns in the report:

21+Days
14-20 Days
13 or Less Days
 
Top