I have a report that listed and sorted by Product Category ID, Product#, and
$Sale by each product. At the product Category ID footer, I also have a
SumOf$Sale by Product Category ID. I would like to have my report sort by the
SumOf$Sale, which is the result of each product ...

I have a report that prints separate pages by department. I need to
suppress the printing of a department page if the year to date net
income is 0 (contained in groupfooter4). I have thought of the
onnodata event but that code doesn't seem to fit this situation. Can

I'm working with a database created by someone else who appears to
have had about the same knowledge level that I do (limited, brute
force).  One of the functions it serves is to create a series of
reports by pulling records from another database.  She went about this

Hi.  What's the general syntax for formatting report detail controls'
forecolor based on the value of a field in the report's data source
that isn't shown?
Background: My report's data source includes a field called

I have been working on various databases for a few months.  All of a sudden,
none of my reports with subreports will print records.  I can see the records
in the print preview but the records will not print.  Only the headers and
footers from the main report print.  Data is there.. ...

This is a repost from microsoft.public.access.
I am running Access2.
I would like to change an existing report from one column to two columns or
vice versa.

Hi. I want to put a rectangle in Details section. But details can grow or
shrink. I can I tell to that control that it must have the same size as
details dection??
Regards,

i am trying to find a way to sort my report by a custom sort method.
the sort should perform as follows:
sort the newest to the oldest:
ie)

I know this can be done, but haven't figured out how yet.  I have what
basically is a summary report that my sql comes up with for the detail
rows.  I want to total these rows in the report and display
immediately below the detail section.  I don't really want to group

I am currently creating a dynamic report which can be a variable
length depending on options the user selects. This means the form can
be between 1 and 3 pages in length.
The problem I am having is that if I set the report to be 1 page in

Im trying to import reports from 2000 adp to 2007 adp and i'm having some
strange problems.  The reports import fine and all the vba code is still
there but it I alter any part of the report and attempt to save it it say ok
saved, but when I try to close the report it says do you ...

I have a report called rptIvoiceLog for which I have created a button to
open it up.  The Event Procedure for the button is:
   stDocName = "rptInvoiceLog"
   DoCmd.OpenReport stDocName, acPreview

I have a report grouped by month...
how do I sum [TotalExpense] in a subreport
and display it in the main report [TotalMonthExpense]
I have a text box [TotalMonthExpense]

Form frmParts has a command button used to print reports. The button's click
event has code   DoCmd.OpenReport strRptName, acViewPreview
Often I don't print the report, but just examine it.  Then I'll get a new
value from the form's combbox and click the command button to preview ...

I use this IIF formula;
=IIf([Address2] Is Null,[Address] & Chr(13) & Chr(10) & [Town] & Chr(13) &
Chr(10) & [County] & Chr(13) & Chr(10) & [Post Code],[Address] & Chr(13) &
Chr(10) & [Address2] & Chr(13) & Chr(10) & [Town] & Chr(13) & Chr(10) &