Access Report Printing Problems

[stgeorge]

PART 1
i use a database that stores service calls from our customers, however, i have several calls logged for the same company. so, when it comes to printing the latest service call the database prints ALL the records for that company. how can i get it to print ONLY the latest entry.

Part 2
this problem is linked to part 1. when printing a service call for a company that has more than one entry the report header only prints on the first call and on none of the others. how can i rectify these problems.

many thanks, i hope someone can help............

 

[scriverb]

Part 1: You need to create a query that perfoms a GroupBy on all the datafields all except the Date field that identifies the Last entered. This column should totaled by the Last function. If you need help with this you need to provide more detailed information about the table and datafields being used.

Part 2: Within the report you can sort the records in the Sorting and Grouping window. Also, you can specify if there is a Group Header and/or footer. Using this Group Header item you can set the Properties of this Section to have a page Break Before this section. That way each and every item will have a page header printed.

Bob Scriver

 

[CVigil]

You wrote, "The report header only prints on the first call and on none of the others." This is correct functionality. You probably only need to move or copy some fields and controls to other sections of your report.

A *report* header prints exactly once for the entire report.

A *group* header prints exactly once for each group; you must define groups to use this feature, of course.

A *page* header prints exactly once at on each page.

What is said about headers in the preceding statements applies equally to footers, of course.

So do you want a header printed for each call, each customer, each page...?

Also take a look at the "RepeatSections" property. From the Help:
----
"You can use the RepeatSection property to specify whether a group header is repeated on the next page or column when a group spans more than one page or column.
Note: The RepeatSection property only applies to group headers on a report."
----

Have a good one!
-- C Vigil =)
(Before becoming a member, I also signed on several posts as
"JustPassingThru" and "QuickieBoy" -- as in "Giving Quick Answers&quot