Search results

  1. P

    Excel Replacing with Zeros

    Hey there, Thanks first of all to all the people who spend their time solving problems on here. My question is, I have a text file with numbers like 6003860012346611. When I try to import this file into excel, it automatically either makes the number look like this 60038600+15 or if I copy...
  2. P

    Countif

    Hey there, Is there a quick expression to put in the control source area of a field on a report that says COUNTIF([Sample Text Field] = "NO") I would like it to only count the occurrences of NO.
  3. P

    Challenging Question!!!

    I would like to know if there is a way to use an LDB Viewer to record the computer name that logged into a certain access database in 2002 format. I do not want to create a separate form for them to log in but rather just record the computer name that logged in. There are several examples out...
  4. P

    Select Case Help

    Hello there, Thanks for all the help you guys give first of all. I have a report that returns values 1,2,3,4,5...each of these values represents a schedule B1,B2,B3,B4,B5. In the OnOpen I was trying to write like 10 IF statements but don't know how to properly do a bunch. I was writing...
  5. P

    Date Function

    Hello all, Thanks first of all for all of the help I always receive in here. My question is I have to fields on a report simply reading from a query. They are Effective Date and Warning Delivered. These are formatted short date with an input mask of 07/12/05. I wondered if you knew of a...
  6. P

    Date Function

    Hello all, Thanks first of all for all of the help I always receive in here. My question is I have to fields on a report simply reading from a query. They are Effective Date and Warning Delivered. These are formatted short date with an input mask of 07/12/05. I wondered if you knew of a...
Back
Top Bottom