Microsoft Access Audit Report

20 pts.
Tags:
Access Database
Access reports
Audit Reports
Audits
IT audits
Microsoft Access
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JennyMack
    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
    4,280 pointsBadges:
    report
  • WayneW1947
    I should also credit Allan Browne for the original Audit software I am using in my database:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following