Results 1 to 3 of 3

Thread: Form SubForm ACCESS 2007

  1. #1
    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.

  2. #2
    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.

  3. #3
    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.

Similar Threads

  1. Not able to have split form in a subform?
    By Quattro in forum Windows Software
    Replies: 4
    Last Post: 02-09-2009, 06:50 PM
  2. How to add browse button to access 2007 form
    By Broot in forum Software Development
    Replies: 3
    Last Post: 31-08-2009, 09:48 AM
  3. Access 2007 subform not refresh
    By avvia in forum Windows Software
    Replies: 2
    Last Post: 13-07-2009, 11:49 AM
  4. MS Access - How to filter subform
    By Zariah in forum Windows Software
    Replies: 3
    Last Post: 05-06-2009, 05:27 PM
  5. Requery of subform in MS access 2007
    By Computer_Freak in forum Tips & Tweaks
    Replies: 1
    Last Post: 16-05-2009, 09:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,820,636.45048 seconds with 17 queries