Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Access 2003 (https://www.askmehelpdesk.com/showthread.php?t=393378)

  • Sep 4, 2009, 04:24 AM
    NIRVANAMAN
    Access 2003
    Sir
    how can I build total amount in subform -form-
    for example
    table contais quantity and price for each product
    and I want to calculate the total amount must be paid
    what I do ?
    Total = quantity * price for each product
    and how can I write this in unbound box in form
  • Sep 4, 2009, 04:41 AM
    ScottGem

    Create a footer for the subform in that footer put an unbound control with the Controlsource of:

    =Sum(Quantity*price)

  • All times are GMT -7. The time now is 04:27 AM.