Form/Report Help

[phamyh]

Hi,

I apologize ahead if I am posting this in the wrong area. It has been awhile since I've done anything with form/report in MS Access. I am seeking guidance on how to do this effectively and efficiently.

What I'm trying to do is build a database that would generate a report for each manager {MGR_ EMPL_ID/MGR_EMPL_NAME}. In that report each of his direct report {EMPL_ID /EMPL_NAME} would have their own page in that report.

After that, I want to send each respective manager an email with a message and his report attached and CC his VP to the email.

I have a table where all my data resides: DATA
I have another table with all my people and attributes: PEOPLE_LIST - VP_NAME, VP_EMAIL, MGR_EMPL_ID, MGR_EMPL_NAME, MGR_EMAIL, EMPL_ID, EMPL_NAME, EMPL_EMAIL.

Where should I go from here?

Thank you so much for your help!

 

[phamyh]

yes... more guidance please... I'm a bit lost there.

 

[phamyh]

The first step, creating a query, this is a basic function of using MS Access. If you are finding this difficult then you need to search YouTube and find a video explanation.

I have all the queries... I just don't know how to create the forms and the report to do what i need to do... I have forms and reports but I don't know how to get it to do what I need to do. Please give me more specific guidance as to get the commands right on the form/report...