|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
Form SubForm ACCESS 2007 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. |
#2
| |||
| |||
Re: Form SubForm ACCESS 2007 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. |
#3
| |||
| |||
Re: Form SubForm ACCESS 2007 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. |
![]() |
|
Tags: access 2007, form, subform |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Not able to have split form in a subform? | Quattro | Windows Software | 4 | 02-09-2009 06:50 PM |
How to add browse button to access 2007 form | Broot | Software Development | 3 | 31-08-2009 09:48 AM |
Access 2007 subform not refresh | avvia | Windows Software | 2 | 13-07-2009 11:49 AM |
MS Access - How to filter subform | Zariah | Windows Software | 3 | 05-06-2009 05:27 PM |
Requery of subform in MS access 2007 | Computer_Freak | Tips & Tweaks | 1 | 16-05-2009 09:56 PM |