Results 1 to 4 of 4
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Summing Data Question (A2K002 SP2)

    I was just given a relatively simple table. The table has three columns, Project, Amount, and Rownumber (see attached). The user wants to know how to add a calculated field to this table. The calculated field is derived as the Amount for Row Number 289 divided by the Amount for Row Number 287 for each project and is to be added at the bottom of the data. They also do not want to do this in a report; a query or code is fine.

    Any suggestions on this. I am not sure of the best way to do this.
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Summing Data Question (A2K002 SP2)

    I don't see an attachment, but you don't add calculated fields to tables. You calculate things in a query.

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Summing Data Question (A2K002 SP2)

    Hans,

    Sorry, but each time I try to add the attachment (which is very small) the system kicks me off or is stating that the Lounge is busy. I could do the calculation in a query but as the data are on different rows, if makes the calculation more difficult then it should be. I will try to post the attachment again later.
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Summing Data Question (A2K002 SP2)

    Ah, so it was you who caused all those Lounge crashes! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    (Just kidding! If you still have problems, PM me)

Posting Permissions

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