Search results

  1. D

    Conditional format a PivotChart

    Hi everyone, I have searched the internet for hours and still havent found an answer to my problem. I have a PivotChart that is fed information from a table. I want the PivotChart (Its a bar chart) to change the background of a series value under certain conditions. If a bar series value is...
  2. D

    Populate fields based on two others.

    The user should: Enter the Expected Quantity in one field. Enter the Faults in the other field. The Lot Size field calculates and displays: [Expected Quantity] - [Faults] Based on the Lot Size the Sample and Fail fields should be filled as follows: Function SampleCal(Lot As Integer)...
  3. D

    SUM each individual column

    I am trying to get the total in each column but it doesn't seem to be working? The SUM of 004 should be 3808 but it comes up as 82844? The SUM of 008 should be 88 etc.. Then the numbers seem to be adding? As the result in each column is getting bigger and bigger :confused: This is my SQL...
Top Bottom