access reports with company letterhead

[Guest]

ACCESS 2003
I have an inspection DB with 50 addresses in it, the forms consists of a
regulation then a yes\no check box. it has 5 different headings on 6 forms
I want to:
Generate a report for the specific address just inspected.
I want the report to be on Company letterhead with the our typical intro
paragraph.
if a yes/no box is checked I want it to show the information and the
corrective action. I assume the correctine actions must be somewhere in a
table?
how can i do this? thank you for your help

 

[Larry Linson]

ACCESS 2003
I have an inspection DB with 50 addresses in it, the forms consists of a
regulation then a yes\no check box. it has 5 different headings on 6 forms
I want to:
Generate a report for the specific address just inspected.
I want the report to be on Company letterhead with the our typical intro
paragraph.
if a yes/no box is checked I want it to show the information and the
corrective action. I assume the correctine actions must be somewhere in a
table?
how can i do this? thank you for your help

Yes, you'll need a separate table with its own unique identifier for the
records (aka "key") for the Corrective Action. I am assuming you already
have a Table that contains the Regulations, and a separate Table with the
Addresses. If this assumption is incorrect, please clarify.

As to company letterhead, you can either have a specific printer preloaded
with letterhead paper and design your reports to begin below the letterhead
area, or you can scan in the letterhead and include it in one of several
types of Control in the Report header or page header of your Report.

Yes, the corrective action information would need to be stored in a Table,
and there would have to be some sort of "linkage" between the regulation and
the corrective action. That is a "foreign key" field containing the unique
identifier of the field in the other table. Most likely, in this case the
Corrective Action should contain a field with the key of the associated
Regulation. But if more than one Regulation can be associated with each
Corrective Action, you may need a "junction table" with keys of both the
Regulation and the Corrective Action tables -- that is a way to represent
what's called a "many-to-many" relationship.

Larry Linson
Microsoft Access MVP

 

[Guest]

Yes I have tables for addresses and regulations, I will make one for the
corrective actions.
Thank you for your help, you have pointed me in the right direction