Search results

  1. A

    Displaying Decimals As Percentages without Rounding on a Report

    I have a field that comes from a make-table and is set to Double. This field is used to display different types of values like .994965 as well as 47 and 1.08. So changing the field type is not an option to meet my need. I need to display all the data that reads .994965 or any number similar...
  2. A

    IIF Statement is too long. Need VBA option

    I have a need to evaluate 185 records and perform a calculation for each record using IIF statements but my IIF's are too long. Basically I want to create a new field called BonusAmt. In this filed I need it to evaluate different columns and produce an answer per row. I do not know VBA very...
  3. A

    Comparing One Record to Another

    I have a situation that I hope can be done without using VBA. Let's say table looks like this. Name Type Amount Percent Bonus John DCP 5000 10 John Sales 4000 5 I need to look at record one and if John's DCP Amount is >=4000 AND his Sales are >=4000 his Bonus amount for...
Back
Top Bottom