Search results

  1. L

    Checking for upper/lower case text

    I need to build a query that will check the name field for Uppercase. Rule is that the name field should be uppercase. We want to find all instances where there is lowercase in the name field. Any suggestions? Thanks...
  2. L

    Query with Multiple "ORs"

    I have a table called Employees. It has approx. 20 fields and roughly 4000 records. Any of they fields may contain a the phrase "data not available." I need to create a query that picks out all records that have the "no data available" phrase in any of the 20 fields. My first thought was to...
  3. L

    Access to Lotus Notes

    I currently use a module that will open MS outlook from Access. Is there a way to open Lotus Notes from Access and send a Lotus Notes e-mail message? Thanks!
  4. L

    Calculating Weekdays

    I am looking for a way to calculate weekdays. I have a field that captures the date a case was opened. My requirement is to track the number of weekdays the case is open, so currently I'm simply doing a datediff between the case open date and today's date. Problem is the user doesn't want...
  5. L

    Truncating Text

    :confused: I have a field called "Office." The data looks like this: STAFF/HR/Finance DIR/OHD/Training etc. I am building a report where all I need to display is the first item in the office string, such as STAFF or DIR. Is there a way for me to tell the report to NOT print anything to...
  6. L

    Workgroup Secrurity Question

    I have never used Access workgroup security and have a question. Will setting up security and/or a workgroup alter the individual database that I am currently working on, or will it alter the settings on the Access application, which will carry over into all databases, both past and future...
  7. L

    Changing Columns to Rows

    I inherited a database that is the back-end of a web based survey. My task is to help the survey analists extract the data. Their requirement is to have the data come out as one row per survey respondent. However, the developer designed the table to collect the data as follows: Each "answer"...
  8. L

    looping through records on a list form

    I have a continuous form that lists action items and their due date. When the user opens the form, I would like the text in the "due date" field to turn red for overdue actoin items. I am stuggling with this and would appreciate any insight. Thanks!
  9. L

    Median Function

    I need to calculate the median of a group of numbers in a query. Excel does this nicely, but I cannot find a function in Access. Does anyone out there know where I can get my hands on such a function to use in Access? Thanks in advance.
  10. L

    Zulu and Julian Date Conversion

    Does anyone know of a function that will convert the system time to Greenwich Mean Time (Zulu)? I am also looking for a function to convert the system date to Julian Date. Any suggestions would be greatly appreciated! Lynn
Back
Top Bottom