Recent content by cacolon

  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

    Thanks for the info. I'll check it out and get back to you. thanks again!
  3. C

    Report Select on a Form

    thanks for the information, but is not what I'm looking for.... to be more specific I'm looking to create a Menu/form in which the user can choose form a list of reports and that it can also input the parameters, such as date, department, etc. from the form using the date widget for example...
  4. 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...
  5. C

    Querie Problem

    OMG worked like a Charm! Thanks a lot!
  6. 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...
See more
Back
Top Bottom