What is it ? Assigned To Name Header / Footer

[s1police]

Dear All,

When I tried to explore someone MS Access, and try to learn how is there report format, however, I found that there is some terms confusing me.

When I opened the report, it contains

- Report Header
- Page Header
- Assigned To Name Header
- Detail
- Assigned To Name Footer
- Page Footer
- Report Footer

Could you please explain, what is the different between them? And Please kindly explain more on Assigned To Name Header / Footer. And how can I call it out. This is the one confusing me.

Thank you very much, expert!!!!

 

[statsman]

Report Header - the section that appears at the very top of the report (and only there). Usually contains a description of the information that is contained in the report.

Page Header - appears at the top of each page if your report is longer than one page, also displayed under the Report Header on your first page. Usually contains the column headings of the data.

Name Header - you have elected to create a report where "Name" is the grouping category. The report will group each section of data by "Name".

Name Footer - where you would place your totals/subtotals for each "Name".

Page Footer - will appear at the bottom of each page of the report. Usually contains the page number, date printed.

Report Footer - appears at the end of the last page of the report. Usually contains Grand Totals and the like.


The Name Header would usually contain the title of the section, in your case the Name of the person that section of the report is about.
The Name Footer would usually contain the totals/subtotals/counts of the data in the Name section.

 

[Moniker]

It also sounds like you're using the wizard instead of just opening a blank report. In a standard Access report, the only things there are Page Header, Detail, and Page Footer. I was referring to Access 2003, but I just confirmed this is the same thing in Design View in a standard Access 2007 blank report.

Page Header - Appears at the top of every page (the report name, maybe a subtitle, for example).

Detail - The actual data of the report. While a header/footer can include real data as well, the meat of the data ends up in detail.

Page Footer - Appears at the bottom of every page (usually a page number, perhaps the location of the file, etc.)

Note that all of this is extremely customizable, so you'll have to explore a bit to see what everything is. I'm sure Northwind has report examples in it. Look at the reports in design view.

Keep in mind that the Detail section is where your detail goes. Sounds simple, but a lot seem to be confused by that. Therefore, for example, if you want to show order details, and then show order totals, the details would go in the Detail section and you'd insert a second set of detail sections above and below the main Detail section.

If that confused you, look into sorting and grouping. And, note that you can rename the sections so that they make more sense. Sample generic layout:

---Report Header---
ABC Company Monthly Report
---Page Header---
Monthly Sales for December 2007
---Section Header--- (custom detail header entry you make)
Item   Amt.   Price
---Detail---
1      23     $10
2      10     $20
3      5      $50
---Section Footer--- (custom detail footer you make)
3      38     $680
---Page Footer---
Page 1 of 3

... in here, Page Header, Section Header, Detail, Section Footer, and Page Footer repeat as necessary ...

---Report Footer--- (appears only at end of report)
Totals for all Sales:  25     400   $5000

Play around with it. It's pretty intuitive once you wrap your brain around it, and that's easier to do if you fiddle with it a bit.

 

[s1police]

THX for your help!!!!

 

[s1police]

Dear All,

I have a question, please help to guide me.

I have a report, it contains Page Header, Name Header, Detail, Page Footer and Report Footer.

I would like to add "Name Footer" in the report, so I can get a total cost for each Name Header. Can you please let me know the procedures how I can add step by step?

May be you let me know where I should click to create Name Footer is OK. Then I can write some VBA for the text field.

Thanks!!!!

 

[s1police]

Oh, I found the solution for this when I practiced. Here is the solution, just share with you all, the steps are as follows,

- In the Report Design View, right click from the ruler bar (see attached MSAccess_Report_sortingandgrouping1.JPG)
- Select Sorting and Grouping
- Manager the Field you want (see attached MSAccess_Report_sortingandgrouping2.JPG)

Hope it can help!!!

Cheers,
Victor