Search results

  1. G

    If and then formula

    Hi, I need help writing a formula that will automatically allow the right price point to be selected. I don't even know if this is possible. I have two "prices each" that need to be selected based on quantity. So if the quantity is less than 1001 then price A would be selected or if the...
  2. G

    Report Missing Data

    Hi, I have a form, jobfolder, on this form I have a command button that open another form, finalreport, that is automatically populated from the first form. Both use the same query for data. So far no problem. In the 2nd form, I have several text boxes that are manually filled in by the user...
  3. G

    Update Old Records

    Hi, This may be a stupid question, but, If I make a change to the design on a form and I want to update previous records to incorporate the change I made how would I go about making this happen automatically without having to go into each old record manually? An example is I just changed a...
  4. G

    Storing a calculated Field on a table

    Hi, I know it breaks all the rules to store a calculated field on a table, but I've painted myself into a corner with the way I built this particular database, not good, I have repeating groups and basically the whole database is built this way. I need one form to store a calculated value on a...
Top Bottom