Need help to get my sales information displayed in columns

[joobi]

I have a table called T-sales with 5 fields which I cant get displayed in a report the way i want.

These are the following fields
1. ID (autonumber)
2. Period - built on YYMM, for example 0811 would mean November 2008. The first period in my table is 0601 (Jan 2006) and the last period 1001 (Jan 2010).
3. Storename - name of a store... In total I have 10 stores different.
4. Sales - sales number for each store and period (accumulated numbers)
5. Result - result number for each store and period. (accumulated)

Below is an example of what the data in the table could look like. In total there is a few hundred rows in the table...

ID    Period     Storename     Sales     Result
635    0811    Storename 1    132         12
636    0811    Storename 2    218         25
637    0812    Storename 1    192         20
638    0812    Storename 2    135         -5
639    0812    Storename 3    188         15

I need a report containing 10 rows (the different store names) with the yearly sales and result for each store under the correct year from 2006 to 2009... In other words like below...

Store name                 2006                         2007             2008   2009
Store name 1   Sales0612 Result0612   Sales0712 Result0712  ......   .....
Store name 2   Sales0612 Result0612   Sales0712 Result0712  ......   .....
Store name 3   Sales0612 Result0612   Sales0712 Result0712  .....    .....
.
.
Store name 10  Sales0612 Result0612   Sales0712 Result0712  .....    .....

Hope for some help here because I am completely lost....

 

[vbaInet]

I have a table called T-sales with 5 fields which I cant get displayed in a report the way i want.

These are the following fields
1. ID (autonumber)
2. Period - built on YYMM, for example 0811 would mean November 2008. The first period in my table is 0601 (Jan 2006) and the last period 1001 (Jan 2010).
3. Storename - name of a store... In total I have 10 stores different.
4. Sales - sales number for each store and period (accumulated numbers)
5. Result - result number for each store and period. (accumulated)

Below is an example of what the data in the table could look like. In total there is a few hundred rows in the table...

ID    Period     Storename     Sales     Result
635    0811    Storename 1    132         12
636    0811    Storename 2    218         25
637    0812    Storename 1    192         20
638    0812    Storename 2    135         -5
639    0812    Storename 3    188         15

I need a report containing 10 rows (the different store names) with the yearly sales and result for each store under the correct year from 2006 to 2009... In other words like below...

Store name                 2006                         2007             2008   2009
Store name 1   Sales0612 Result0612   Sales0712 Result0712  ......   .....
Store name 2   Sales0612 Result0612   Sales0712 Result0712  ......   .....
Store name 3   Sales0612 Result0612   Sales0712 Result0712  .....    .....
.
.
Store name 10  Sales0612 Result0612   Sales0712 Result0712  .....    .....

Hope for some help here because I am completely lost....

Looks like you need a Crosstab query which your report will be based upon. Try searching on that topic and see how you get on.