Please Help??!! Report Totals

A

A. Smart

This is probably an easy one!!

I have a report that lists the number of projects completed, on the report I
would like to see a total of the number of projects/records (completed) that
the query returns. How do I do this?
Cheers
 
O

Ofer

One option is
On the detail section where the report are listed you can add another field,
not visible, in it control source you write
=iif([ProjectCompleteField]=true,1,0)
In the running sum properties of the field select yes.
In the buttom of the report create another field, that reference the field
you created above

=[FieldNameFromAbove]
 
A

A. Smart

Im getting an error in the total heres wat Ive got.
WI Progress for this particular report is Completed
In detail section

=IIf([WI Progress]=true,1,0) (Named Sum)

In Report Footer

=[Sum]
Please can u advise. Cheers

Ofer said:
One option is
On the detail section where the report are listed you can add another field,
not visible, in it control source you write
=iif([ProjectCompleteField]=true,1,0)
In the running sum properties of the field select yes.
In the buttom of the report create another field, that reference the field
you created above

=[FieldNameFromAbove]


A. Smart said:
This is probably an easy one!!

I have a report that lists the number of projects completed, on the report I
would like to see a total of the number of projects/records (completed) that
the query returns. How do I do this?
Cheers
Click to expand...
Click to expand...
 
A

A. Smart

Not to Worry, cracked it.

Thanks once again for your help!!

Regards

A. Smart said:
Im getting an error in the total heres wat Ive got.
WI Progress for this particular report is Completed
In detail section

=IIf([WI Progress]=true,1,0) (Named Sum)

In Report Footer

=[Sum]
Please can u advise. Cheers

Ofer said:
One option is
On the detail section where the report are listed you can add another field,
not visible, in it control source you write
=iif([ProjectCompleteField]=true,1,0)
In the running sum properties of the field select yes.
In the buttom of the report create another field, that reference the field
you created above

=[FieldNameFromAbove]


A. Smart said:
This is probably an easy one!!

I have a report that lists the number of projects completed, on the report I
would like to see a total of the number of projects/records (completed) that
the query returns. How do I do this?
Cheers
Click to expand...
Click to expand...
Click to expand...
 
P

PC Datasheet

"Sum" is a reserved word. Chanbge the name to "Total" and see if it works.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

A. Smart said:
Im getting an error in the total heres wat Ive got.
WI Progress for this particular report is Completed
In detail section

=IIf([WI Progress]=true,1,0) (Named Sum)

In Report Footer

=[Sum]
Please can u advise. Cheers

Ofer said:
One option is
On the detail section where the report are listed you can add another
field,
not visible, in it control source you write
=iif([ProjectCompleteField]=true,1,0)
In the running sum properties of the field select yes.
In the buttom of the report create another field, that reference the
field
you created above

=[FieldNameFromAbove]


A. Smart said:
This is probably an easy one!!

I have a report that lists the number of projects completed, on the
report I
would like to see a total of the number of projects/records (completed)
that
the query returns. How do I do this?
Cheers
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

Good suggestion. Also, you don't need to set up running sum to do this. Just
add a control to your report or group footer with a control source of:
=Sum(Abs([WI Progress]))



--
Duane Hookom
MS Access MVP
--

PC Datasheet said:
"Sum" is a reserved word. Chanbge the name to "Total" and see if it works.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

A. Smart said:
Im getting an error in the total heres wat Ive got.
WI Progress for this particular report is Completed
In detail section

=IIf([WI Progress]=true,1,0) (Named Sum)

In Report Footer

=[Sum]
Please can u advise. Cheers

Ofer said:
One option is
On the detail section where the report are listed you can add another
field,
not visible, in it control source you write
=iif([ProjectCompleteField]=true,1,0)
In the running sum properties of the field select yes.
In the buttom of the report create another field, that reference the
field
you created above

=[FieldNameFromAbove]


:

This is probably an easy one!!

I have a report that lists the number of projects completed, on the
report I
would like to see a total of the number of projects/records
(completed) that
the query returns. How do I do this?
Cheers
Click to expand...
Click to expand...
Click to expand...
 
Top