Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-05-2009
Member
 
Join Date: May 2009
Posts: 2
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.
Reply With Quote
  #2  
Old 30-05-2009
Member
 
Join Date: Oct 2008
Posts: 167
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.
Reply With Quote
  #3  
Old 30-05-2009
Member
 
Join Date: May 2009
Posts: 2
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Form SubForm ACCESS 2007"
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


All times are GMT +5.5. The time now is 05:49 PM.