Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    6

    Question Unanswered: Calc values in a table

    I am creating a db and need to be able to calc values from 2 or more fields and display the totals in the database for example; Register sales - Pay outs = general deposit; I need to be able to enter totals in the Register sales and pay outs fields and display the totals in the General Deposits field. Also need to take the calc total and add or subtract from it, and display the totals in another field. How can I do this?

  2. #2
    Join Date
    Aug 2003
    Posts
    68
    I would suggest putting the calcs in a query and displaying that to the user.
    Unless you would rather run update queries during certain times to populate the table...
    jm

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi rd_dragon

    As jmayo suggested is correct. You have your tables to maintain all your relative non-changing data and do calculations in Queries/Forms/Reports.
    Here ya go:
    Fields ]b]REGISTER PAYOUTS[/b]

    In your form after you create a query with all associated fields place a TextBox to the end of the row with the above fields, and inside place this:

    =[REGISTER]-[PAYOUTS]
    This would be the box named something like GENERAL DEPOSIT

    NEXT..at the bottom of the form (preferrably under text box just created) and place this in it:

    =SUM([REGISTER]-[PAYOUTS])

    Set this TextBox for Currency and you're done. The same goes for the Report as well.

    Need further help come back again and we'll go from there.

    Bud

Posting Permissions

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