Welcome to SPN

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

Sign Up Now!

Need Calculated Fields in Table View

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

  1. JB

    JB
    Expand Collapse
    Guest

    Hi,

    I currently store treasury bill information in Approach 9 and have the DB
    working just like I want it except that mouse scrolling does not work with
    Windows XP.

    To remedy this I started a new DB in Access 97.

    The problem is getting two calculated fields in the table view. I know this
    can be done with a query but I want it in the table as I need to view all
    fields at once and be able to sort on any field.

    My workaround for now is to enter the data in Excel and link the spreadsheet
    to Access. That works fine but there must be a more efficient way and I
    would appreciate any tips.

    Thank you.

    Mike
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Mike,

    You should not attempt to store a calculated result in a table. Doing so
    violates database normalization rules. Here is a paper by Database Design
    expert Michael Hernandez:

    http://www.datadynamicsnw.com/accesssig/downloads.htm
    (See the last download titled "Understanding Normalization")

    It includes the following quote on page 23:

    "The most important point for you to remember is that you will always
    re-introduce data integrity problems when you de-Normalize your structures!
    This means that it becomes incumbent upon you or the user to deal with this
    issue. Either way, it imposes an unnecessary burden upon the both of you.
    De-Normalization is one issue that you'll have to weigh and decide for
    yourself whether the perceived benefits are worth the extra effort it will
    take to maintain the database properly."


    You should do your calculations in a query. You can display all fields from
    a table in a query, and sort to your heart's content.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "JB" wrote:

    > Hi,
    >
    > I currently store treasury bill information in Approach 9 and have the DB
    > working just like I want it except that mouse scrolling does not work with
    > Windows XP.
    >
    > To remedy this I started a new DB in Access 97.
    >
    > The problem is getting two calculated fields in the table view. I know this
    > can be done with a query but I want it in the table as I need to view all
    > fields at once and be able to sort on any field.
    >
    > My workaround for now is to enter the data in Excel and link the spreadsheet
    > to Access. That works fine but there must be a more efficient way and I
    > would appreciate any tips.
    >
    > Thank you.
    >
    > Mike
     
  4. Jesse

    Jesse
    Expand Collapse
    Guest

    You can use a query to do it just don't include any filter criteria for
    it.
     
  5. JB

    JB
    Expand Collapse
    Guest

    "Jesse" <monk@coqui.net> wrote in message
    news:1148288301.168901.50800@y43g2000cwc.googlegroups.com...
    > You can use a query to do it just don't include any filter criteria for
    > it.
    >


    OK...I am going to give it a try. Thank you Jesse.
     
  6. JB

    JB
    Expand Collapse
    Guest

    I was aware that it's not recommended but it works so well in Approach and
    the DB is so simple I figured I could get away with it.

    But you say I can view and sort all fields in a query so that will solve the
    problem.

    Thank you very much Tom.



    "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
    news:EE197DE3-1294-49EB-96CD-0C9F07E8232C@microsoft.com...
    > Hi Mike,
    >
    > You should not attempt to store a calculated result in a table. Doing so
    > violates database normalization rules. Here is a paper by Database Design
    > expert Michael Hernandez:
    >
    > http://www.datadynamicsnw.com/accesssig/downloads.htm
    > (See the last download titled "Understanding Normalization")
    >
    > It includes the following quote on page 23:
    >
    > "The most important point for you to remember is that you will always
    > re-introduce data integrity problems when you de-Normalize your
    > structures!
    > This means that it becomes incumbent upon you or the user to deal with
    > this
    > issue. Either way, it imposes an unnecessary burden upon the both of you.
    > De-Normalization is one issue that you'll have to weigh and decide for
    > yourself whether the perceived benefits are worth the extra effort it will
    > take to maintain the database properly."
    >
    >
    > You should do your calculations in a query. You can display all fields
    > from
    > a table in a query, and sort to your heart's content.
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "JB" wrote:
    >
    >> Hi,
    >>
    >> I currently store treasury bill information in Approach 9 and have the DB
    >> working just like I want it except that mouse scrolling does not work
    >> with
    >> Windows XP.
    >>
    >> To remedy this I started a new DB in Access 97.
    >>
    >> The problem is getting two calculated fields in the table view. I know
    >> this
    >> can be done with a query but I want it in the table as I need to view all
    >> fields at once and be able to sort on any field.
    >>
    >> My workaround for now is to enter the data in Excel and link the
    >> spreadsheet
    >> to Access. That works fine but there must be a more efficient way and I
    >> would appreciate any tips.
    >>
    >> Thank you.
    >>
    >> Mike
     
  7. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    JB wrote:
    > I was aware that it's not recommended but it works so well in
    > Approach and the DB is so simple I figured I could get away with it.
    >
    > But you say I can view and sort all fields in a query so that will
    > solve the problem.
    >
    > Thank you very much Tom.


    Do try to normalize the data. We don't recommend this just because it
    is a rule, we recommend it because we have all seen the results of what
    happens when you don't. Most of us have thought we knew better before we
    learned.

    >
    >
    >
    > "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
    > news:EE197DE3-1294-49EB-96CD-0C9F07E8232C@microsoft.com...
    >> Hi Mike,
    >>
    >> You should not attempt to store a calculated result in a table.
    >> Doing so violates database normalization rules. Here is a paper by
    >> Database Design expert Michael Hernandez:
    >>
    >> http://www.datadynamicsnw.com/accesssig/downloads.htm
    >> (See the last download titled "Understanding Normalization")
    >>
    >> It includes the following quote on page 23:
    >>
    >> "The most important point for you to remember is that you will always
    >> re-introduce data integrity problems when you de-Normalize your
    >> structures!
    >> This means that it becomes incumbent upon you or the user to deal
    >> with this
    >> issue. Either way, it imposes an unnecessary burden upon the both of
    >> you. De-Normalization is one issue that you'll have to weigh and
    >> decide for yourself whether the perceived benefits are worth the
    >> extra effort it will take to maintain the database properly."
    >>
    >>
    >> You should do your calculations in a query. You can display all
    >> fields from
    >> a table in a query, and sort to your heart's content.
    >>
    >>
    >> Tom Wickerath
    >> Microsoft Access MVP
    >>
    >> http://www.access.qbuilt.com/html/expert_contributors.html
    >> http://www.access.qbuilt.com/html/search.html
    >> __________________________________________
    >>
    >> "JB" wrote:
    >>
    >>> Hi,
    >>>
    >>> I currently store treasury bill information in Approach 9 and have
    >>> the DB working just like I want it except that mouse scrolling does
    >>> not work with
    >>> Windows XP.
    >>>
    >>> To remedy this I started a new DB in Access 97.
    >>>
    >>> The problem is getting two calculated fields in the table view. I
    >>> know this
    >>> can be done with a query but I want it in the table as I need to
    >>> view all fields at once and be able to sort on any field.
    >>>
    >>> My workaround for now is to enter the data in Excel and link the
    >>> spreadsheet
    >>> to Access. That works fine but there must be a more efficient way
    >>> and I would appreciate any tips.
    >>>
    >>> Thank you.
    >>>
    >>> Mike


    --
    Joseph Meehan

    Dia duit
     

Share This Page