Results 1 to 4 of 4
  1. #1
    Rasha is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    12

    insert a specific date in report footer

    hi all.
    i design a report .. this report represent a multiple data but to a unique record example...
    a room code 487, and all its specification ( electric,safety,telecommunication,........) ... now i need to add a 3 dates in the footer
    1- when this record is created


    2-when this record is modified
    3- the number of modification
    how can i do such like this ....
    thank you

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Data needs to be input to a record. Then the data will be available for report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Rasha is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    12
    Ok ... how can i insert these types of date
    such as ... the first created ..... i found it the function Now() ... wrote it in the default value ...so its done
    but the modified date if i enter and modify any data in the record .... how can i insert it
    and the last one is how many modification Done in this record

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you want to keep count of record edits, options:

    1. a related table for the record ID, date of edit, who edited, why edited. Then a query can count these records and pull the latest date for each record.

    2. every time record is edited, code changes the edit date field and increments a number in another field
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  2. IIf Function in Report Footer
    By Ron H. in forum Access
    Replies: 3
    Last Post: 12-21-2013, 04:05 AM
  3. Replies: 1
    Last Post: 10-02-2013, 01:14 AM
  4. Insert Image associated to specific value
    By albe_ACC in forum Reports
    Replies: 5
    Last Post: 09-19-2011, 03:02 PM
  5. Problems with SUM in Report Footer
    By bonetakc in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 04:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums