Results 1 to 2 of 2
  1. #1
    kosti is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    6

    Unhappy Help me please with 1 question:

    1. When filling a form I want to automate a field value as division of another field with a value in a query :
    Ex. fields in the form:
    Product, quantity , Cost
    and fields in the query:
    Product, Total cost


    I want the field in the form: Cost = Query.totalCost/form.quantity

    How to do that ?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do it in your query and bind the results to a control on your form.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums