Calculations in Access forms/tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McClelland (anonymous_at_discussions.microsoft.com)
Date: 07/26/04

  • Next message: SimpleTechie: "Re: Customizing Parameters to data access page" 
    Date: Mon, 26 Jul 2004 05:59:22 -0700

    Hi,

    I have built a database that contains several forms for
    inputting data to associated tables. The forms use some
    drop down lists from several tables.

    The main form used on a daily basis also calculates values
    based on some figures that are input directly on the form.

    My Problem.

    The table associated with this form shows all of the
    inputted values from the form, but not the calculated
    values.

    I really need these calculated values in the Table because
    I want to design reports that will read from the table.

    Any help greatly appreciated.

    Regards

    David McClelland

  • Next message: SimpleTechie: "Re: Customizing Parameters to data access page"

    Relevant Pages

    • RE: Access 2000 Slowdown
      ... How many sub-directories deep is the database saved in? ... nothing to do with the db, but rather the network. ... When you get this message, moving from one control to another, is there code ... "Generally we only have one person inputting data to the database at any ...
      (microsoft.public.access.gettingstarted)
    • Re: Can a form have two record sources?
      ... > I have contructed a database for questionnaire purposes, ... > My problem/question is can a form be based on two record sources? ... So far we have found that when inputting data we ...
      (microsoft.public.access.forms)
    • Re: Where can I download this type of db example?
      ... Take a look in the Northwind Traders database that comes with Access. ... The Orders form (which uses the Orders Subform form) illustrates how to do ... queries and forms for this kind of table structure. ... more sophistication on inputting data into forms that access multiple ...
      (microsoft.public.access.formscoding)
    • Re: Dumb Question of the day (maybe year)
      ... >> I am using phpMyAdmin to access MySQL for inputting data - built one ... >> Second table includes a date (configured as date not datetime). ...
      (alt.php)
    • Access 2000 Slowdown
      ... My client's database is set up with a split database, ... backend .mdb files. ... "Generally we only have one person inputting data to the database at any ...
      (microsoft.public.access.gettingstarted)