Results 1 to 2 of 2

Thread: [RESOLVED] Dividing 2 fields in your detail (Access)

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Resolved [RESOLVED] Dividing 2 fields in your detail (Access)

    Hi,

    I got a report with a field "Retail_Price" and a field "Last_Cost", the field after that is the Mark up %. I would like to display in the Markup Field the Retail_Price divided by the Last_Cost. Does anyone know the formula that I would put int he control source of the Markup field?

    Thanks

  2. #2
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: [RESOLVED] Dividing 2 fields in your detail (Access)

    sorry, i couldnt understand the control source.
    the formula, ofcourse you might be knowing "=Retail_Price/Lost_Code"
    I am sorry if I am wrong
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


Posting Permissions

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



Click Here to Expand Forum to Full Width