Report Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is replacing a manual form. The form must remain intact
and can only display 8 detail records per page. Thanks to those who
responded to my post yesterday to help me with this. However, I still have a
problem, there is additional information that has to print under the detail.
Therefore, when I get my page break, I lose the information at the bottom of
the page. I tried placing the footer information that needs to display after
the detail in the report footer. However, the problem with this is that the
footer must fit up very close to the detail information which is variable to
form a grid. When I put this group footer information in a page footer, it
is bottom floating and does not hit the detail grid, leaving a gap. What I
am really looking to do is to print a "sub group footer" per page when detail
records are more than 8, but still print the group footer on the page if the
records are less than 8.

Any ideas?
 
Is your design specification to print a group footer after every 8th record
and following the last record? If so, consider a calculation in the query
that divides your query records into groups of 8. The following SQL will
create groups of 8 records in the Orders table in Northwinds

SELECT Orders.OrderID, Orders.OrderDate, (Count(Orders_1!OrderID)-1)\8 AS
Group8
FROM Orders, Orders AS Orders_1
WHERE (((Orders_1.OrderID)<=[Orders]![OrderID]))
GROUP BY Orders.OrderID, Orders.OrderDate
ORDER BY Orders.OrderID;

Your report can then group by the column Group8.

If that isn't what you want then try ask again.
 
Back
Top