Home > IT Answers > Security > Microsoft Access Audit Report
WayneW1947
20 pts.
0
Q:
Microsoft Access Audit Report
Audits, IT audits, Audit Reports, Microsoft Access, Access Database, Access reports
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I also want to eliminate all blanks after the first blank to 'snug up' the report.
ASKED: Jun 29 2009  8:56 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Snikrah
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I submitted an answer already to this, but it never showed up...

The bare bones of the problem I see as:

1. It depends on your table and field structure.
2. An historical record table is assumed.
3. May wish to use use TOP in your select query-behind-the-report. TOP 2, for example.
4. May wish to use the "can grow" property of your report text boxes.
5. A sub-report may be of value, depending on the nature of the data being displayed.

Is any of this of help?

Would you like to supply more information?
Last Answered: Jul 14 2009  5:21 PM GMT by Snikrah   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

JennyMack   3205 pts.  |   Jun 29 2009  9:23PM GMT

This is an MS ACCESS Database.

Moderator note: Follow-up comment from WayneW1947 was created as another question; I have moved it here. In the future, please add all additional information into the discussion area of the original question, rather than posting in a new one.

Thanks,
Jenny
Community Manager

 

WayneW1947   20 pts.  |   Jul 1 2009  1:11PM GMT

I should also credit Allan Browne for the original Audit software I am using in my database:

 
0