Form SubForm ACCESS 2007

[streetprods]

Hi,

I am a newbie in Access 2007. I would like to know if what I want to do it is possible.

I will have two or three table to deal with.
One will be the table where I will run my query from.
The second will store Some Data

When I want to do is:

The form will have information about target for each players.
Target one:
Target two:
Target Three:
Target Four:
Target Five

next I want a subform to run query based on the name of players and bring the result of each target.

After I would like to third subform to calculate if they have hit their target and they will get.

Do you think it is possible????

I would love to have a big help in that case.

[Adley]

You need to set the Pivot table out of your list of table,Pivot table would be the main table which will consist of more detailed than this. There are two ways the total information is broken down, into Player rows and into run columns. But for deeper analysis you need to subdivide your columns into more columns and you could subdivide my rows into more rows.

[streetprods]

Ok - I will need to have look into the pivot more in detail.

I think you will need to see my database to have the full understanding,of what I want to achieve. and we can work through it if you do not mind.