Report Totals

[Kissi Asiedu]

Hi,
Can someone please help me with the following in a report total?
I have fields ZONE; LINE. Filed ZONE holds data Checking, Pulling and Cuts.
LINE holds corresponding lines for each ZONE data. I want to have the total
of LINE for Pulling and Cut but not Checking in the report footer.
Example:
ZONE LINE
Checking 20
Pulling 10
Cuts 5

TOTAL LINES = 15

Please help.

[Larry Linson]

Re: Report Totals

A simple approach would be to include a Calculated Field in the Query, which
is the number of lines IF Zone = "Pulling" or Zone = "Cut", as XLines, and
put the total of XLines in the appropriate Footer... Group and/or Report.
If you get an error, create a TextBox for XLines in Detail, but set its
Visible property to No.

Larry Linson
Microsoft Access MVP


"Kissi Asiedu" <kissi5559@aol. comwrote in message
news:kT6Eg.1627 8$s51.500@fe62. usenetserver.co m...

Hi,
Can someone please help me with the following in a report total?
I have fields ZONE; LINE. Filed ZONE holds data Checking, Pulling and
Cuts. LINE holds corresponding lines for each ZONE data. I want to have
the total of LINE for Pulling and Cut but not Checking in the report
footer.
Example:
ZONE LINE
Checking 20
Pulling 10
Cuts 5
>
TOTAL LINES = 15
>
Please help.
>
>