Search results

  1. C

    IFF Statement with Multiple conditions

    HI All. I'm trying to create an IIF statement to calculate a Price on an item given certain conditions on ACCESS. For example: TotalCost: IIF([ColorType]="B/W" and IIF([Machine]= "Ricoh 3510" or "Ricoh 8200-1" or "Ricoh 8220-1" or "Ricoh 8220-2" then [UnitsRequested]*0.0039,0)) I don'y know...
  2. C

    Report Select on a Form

    Hi all. I have several reports that are run daily and I have to do them one by one. is there a way to make a form that invokes each report and give me the option of making the input of the report variables within the form itself? for example, date or date range and department, among other...
  3. C

    Querie Problem

    Hello to All! I'm trying to make a formula in a querie that add 2 fields. each of those fields is the result of a division. Sometimes one of the fields get a 0/0 division wich gets me an error. I'm trying to tell the system that if that calculation is an error just display the other field as if...
Back
Top Bottom