Search results

  1. E

    Changing field names

    Better late than never I hope. If you have the labels attached to the text boxes, what is entered in the lable for a caption will display as the column header. If the text box has no label, create a label with the appropriate caption, cut it, select the correct text box and right-click, paste...
  2. E

    color subform column

    Check Conditional Formatting, you can change font weight, color and back color in datasheet mode with it. Shawn
  3. E

    bring value forward to field from previous record

    I had a similar problem, what I did was to add an Autonumber field to the table, I then ran a query that had a calculated field that subtracted one number from the autonumber and ran another query that linked the table to itself by linking the Autonumber to the calculated field and putting the...
  4. E

    Date Differences

    Thanks, but I only have the current date, or is there a way to pull the previous record value for date into the current record for comparison? Or am I missing something (wouldn't surprise me).
  5. E

    Date Differences

    Sorry to be a pain, but does that include finding mean time between records and not just from today, for instance: 1 01/01/01 2 01/03/01 Time between: 2 days 3 02/02/02 Time between: 30 days etc.
  6. E

    Date Differences

    Hi, new guy here. I have a table with a date field and I need to have a field (presumably calculated) that lists the amount of time since the last record. I had thought of bringing the date from the previous record into the next record and subtracting the two, but I cannot figure out how to do...
Back
Top Bottom