Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    13

    Unanswered: Calculating Different Fields from Different Tables

    Hi..
    Could someone help me here please ?
    Am trying to calculate 2 fields from 2 different tables and putting the sum in a field in a another different table

    like for example I have

    Table1 with a field for Points of Sales
    Table2 with a field for Points of Evaluation
    Table3 with a field for Total Points

    I want to add Field " Point of Sales " and Field of " Point Of Evaluation" together to have it in Field " Total Points "

    But I can't figure the right way

    Thanks advanced

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Why???? Are these fields static? They are not subject to change? If not you're better served to run a query on them and put the result(s) in a form or report ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by M Owen
    Why???? Are these fields static? They are not subject to change? If not you're better served to run a query on them and put the result(s) in a form or report ...

    Must say I agree with the Grand Poobah....
    No real need that I know of to create a Table just to store that value. As suggested, calculate it in a Form/Report or Query. I've been told the only reason to store it the way you are wanting to is if it is for historical reasons.

    have a nice one,
    BUD

  4. #4
    Join Date
    Mar 2004
    Posts
    118
    This is the way I see it:

    You have:

    x table with Value i
    y table with Value a

    You want to add Values i & a and put them in another table, lets call it Z.

    You make an update query

    Where key in table x = foreign key in table y update table z with value (i+a)

    Youll need all 3 tables linked properly in this update query with the Z table in the middle.

    Sorry I cannot be any more help without knowing the exact table names/fields etc.

    Ofcourse you can do it in VB much more elegantly.

Posting Permissions

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