How to create this form or report

[azu_daioh]

I have a table with the following fields:
[LicenseNum], [yrYear], [ttlPaid]

which couldh have the following data:
A1234 - 2003 - $2,309,390
A1234 - 2004 - $3,209,000
A1234 - 2005 - $4,599,999
G100 - 2005 - $1,999,999
G100 - 2006 - $2,000,000
G100 - 2007 - $999,999


I want a form but preferable a report to display the records like
this:
License# [Year1] [Year1]+1 [Year1]+2 [Year1]+3

So if I enter 2004 for [Year1], I would get something like this:

License# -- 2004 -- 2005 -- 2006 -- 2007
A1234 -- $3,209,000 -- $4,599,999
G100 --- [blank] -- $1,999,999 -- $2,000,000 -- $999,999

Thank you,

 

[akphidelt]

To do this I would first create a crosstab query. What you would want is to
have the LicenseNum as the Row Heading, yrYear as the column heading, ttlPaid
as the value. This would create the affect you are looking for then if you
had tons of years of data and want to only show the 4 years you described you
can create a criteria under the yrYear column heading which says something
like Between Forms!yourform!youryear And Forms!yourform!youryear + 3. This
would give you the 4 years as your column headings.

Let me know if you need any more explanation

 

[azu_daioh]

Thank you so much. This is exactly what I need -- now I need to figure
out how to display yearly total over $1,000,000 only.

 

[akphidelt]

Under the criteria for the ttlPaid field put in

1,000,000