Search results

  1. G

    Using the Date() function

    ACCESS 2003 I am creating a report that has two date fields: HireDate and EndDate. The EndDate field in some records has a value, but most of them are empty (null). Where null, I want to insert the Current Date from whence I can determine how long a person has worked. I am trying to use an IIF...
  2. G

    Drop-down list

    I have inherited two forms, one that creates drop-down list data, and the other that reads and displays that data. The first form seems to work perfectly. It inputs and saves 5-char mnemonics that start with the letter "T". In Design View the leading "T" is displayed. When the second form...
  3. G

    Access Report Parameter Query

    I have inherited a Report that includes a Parameter Query to input a value. I want to change the 'user prompt'. The Parameter Query does not appear to be part of the underlying data query that supports the Report. And I do not find anything in the Report that sets up the Parameter Query. Any...
  4. G

    Report Calculation - Access 2003

    I have inherited an Access DB that accumulates 'hours worked' by name and date. I also inherited a cross-tab query that displays monthly totals by name and month. Each row is for a different person and each column is for a different month. I use the Report Wizard to create a report that reads...
Back
Top Bottom