Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Home user question.

Discussion in 'Information Technology' started by Johnny1r, Jul 28, 2006.

  1. Johnny1r

    Johnny1r
    Expand Collapse
    Guest

    Hello and thanks for looking at my question! I want to make a database
    for our Softball teams . For openers I have a table with 3 fields,
    Player, Hits and Atbats. If someone could just steer me in the right
    direction as to which object ( table, Report, ect.) view and how and
    where to enter a formula (Hits/Atbats)to get the B_avg. Thanks in
    advance for your help. John
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh Temple Observes Tradition By Feeding Downtown Spokane's Homeless - The Spokesman-Review Breaking News Sep 18, 2016
    Sikh News 'The Sikh Project' Book Brings Photo Exhibit Portraits Home - NBCNews.com Breaking News Sep 16, 2016
    The Salmon Story, Finding Home Sikh Sikhi Sikhism Jul 29, 2016
    Homeopathy And Sikhism Hard Talk Jul 1, 2016
    SWAT: Giving Homeless People in London a Christmas Sikh Organisations Dec 22, 2015

  3. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Before going to much farther, consider using three tables:
    TblPlayer
    PlayerID
    PlayerFName
    PlayerMI
    PlayerLName

    TblGame
    GameID
    GameDate
    GameLocation

    TblPlayerGame
    PlayerGameID
    GameID
    PlayerID
    AtBat
    Hits

    You would get the batting average from a calculated field in a query. Build
    a query based on TblPlayer to get the player's name and TblPlayerGame to get
    the number of times AtBat and total hits. Click on the Sigma (looks like
    capital E) button on toolbar at the top of the screen. Under AtBat, change
    GroupBy to Sum and under Hits, change GroupBy to Sum. In a blank field in
    the query, put this expression:
    BattingAverage:[Sum Of Hits]/[Sum Of AtBat]


    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "Johnny1r" <johnny1r@yahoo.com> wrote in message
    news:6JydnRlhdsqnnejZRVn-iw@comcast.com...
    > Hello and thanks for looking at my question! I want to make a database
    > for our Softball teams . For openers I have a table with 3 fields,
    > Player, Hits and Atbats. If someone could just steer me in the right
    > direction as to which object ( table, Report, ect.) view and how and
    > where to enter a formula (Hits/Atbats)to get the B_avg. Thanks in
    > advance for your help. John
     
  4. Johnny1r

    Johnny1r
    Expand Collapse
    Guest

    Thank you, thank you, thank you!! you have just answered a great many
    questions for me. I will definetly work with this. Thanks again, John
    :)



    PC Datasheet wrote:

    > Before going to much farther, consider using three tables:
    > TblPlayer
    > PlayerID
    > PlayerFName
    > PlayerMI
    > PlayerLName
    >
    > TblGame
    > GameID
    > GameDate
    > GameLocation
    >
    > TblPlayerGame
    > PlayerGameID
    > GameID
    > PlayerID
    > AtBat
    > Hits
    >
    > You would get the batting average from a calculated field in a query.
    > Build a query based on TblPlayer to get the player's name and
    > TblPlayerGame to get the number of times AtBat and total hits. Click
    > on the Sigma (looks like capital E) button on toolbar at the top of
    > the screen. Under AtBat, change GroupBy to Sum and under Hits, change
    > GroupBy to Sum. In a blank field in the query, put this expression:
    > BattingAverage:[Sum Of Hits]/[Sum Of AtBat]
     
  5. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:wH7dg.6425$x4.1537@newsread3.news.pas.earthlink.net...

    --

    To Steve:
    You answered OP's question (which is good) BUT:

    No-one wants your advertising/job hunting here!
    'Resource ???? 1175 users ???? Are you kidding ????
    ==>> You mean that 1175 users have been spammed by you ??


    To the original poster:
    Steve answered your question and you allready thanked him for that (which is good) BUT:

    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    Steve is a notorious job hunter in these groups, always trying to sell his services.

    He is known here as a *shameless liar*, with *no ethics at all*.
    If you provided a valid email address he might even spam you with an offer for payed help

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html
    Over 900 !! users (rapidly increasing..) from the newsgroups have visited the website to read about this fake 'resource'

    Arno R
     

Share This Page