Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calculated fields (2k)

    I need to get a couple of calculated fields into 2 different tables:

    Table A uses a field from the same table and performs a calc ( *1.05) for its result.

    Table B uses two fields from Table A and concatenates them.
    The calculated fields need to be dynamic so when, for example ValueA Record2 is changed from 15 to 30
    the calculated field AUTOMATICALLY becomes 31.50 and TABLE_B Concatenate field Record 2 becomes 30Bill.

    How do I do this?

    The result should look like the following:

    <table border=1><tr><td valign=bottom>Fomula:</td><td align=right valign=bottom>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculated fields (2k)

    You should never store calculated fields in a table. It's against all the normalization rules.
    Replace your Table_B by a query (based on Table_A) that calculate the concatenated field. It will always reflect the content of Table_A
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculated fields (2k)

    Francois

    Thanks. I'm new to Access and am trying to break thought modes built from 15 years of Excel use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •