Search results

  1. P

    Need to replace some characters in my field

    Hi, One of my fields has <li> in the data. I need the <li> to be there for posting to the web, but... I also need to make an Access report using this data minus the <li>. How do I strip it out for reporting purposes, Do I use an If statement and "if so" how do I write it... Actually After...
  2. P

    Replacing Field names in a Report

    Hi, I have a report (report A) driven by a query (Query A). I want to copy the report because of the formatting. So now I have report b that needs to be driven by Query B. Is there a way to change all of the fieldnames in the report using a find and replace? Ex. querya.field1 needs to be...
  3. P

    IIF statement and multiple criteria

    Hi, I am trying to use an iif statement in my report. I have a field [field1] and it is has four data points 1,2,3,4 I want to say when [field1]=1,"Statement1" and when [field1]=2,"Statement2" and when [field1]=3,"Statement3" and when [field1]=4,"Statement4" Any help on this would be...
Back
Top Bottom