Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add items in a table (access 2003)

    I have a table for purchase orders. I have a column for each fiscal year, I want the column "grand total" to be the total of the amounts in each fiscal year column. I want the "grand total" amount to be stored in the table. How do I do this?

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

    Re: add items in a table (access 2003)

    It would be better to have a field for the fiscal year and a field for the amount. The table would contain separate records for each fiscal year. That way, you can simply use a totals query to calculate the total.

    But even in the current setup, you shouldn't store the grand total in the table, since it is derived information. You can calculate the grand total in a query by adding the fields for the fiscal years.

Posting Permissions

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