Help with Summary Report

A

Ayo

This is my situation. I have a report with 4 text boxes.
Box Value
1 =DLookUp("[Project Name]","InScope Table","[Project
Number=Reports!
[Project CV Summary]txtProjectNumber.Value")
2 =Project Number
3 =DSum("[AT&T Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved' AND [Purchase Order
Item]
<>""")
4 =DSum("[Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved'")

Box 2 is txtProjectNumber. The report is group by Project Number. I have 5
Project Numbers. The Project Name and Project Number seem to be working fine,
boxes 1 and 2. My problem is with boxes 3 and 4. The DSum function doesn't
seem to be working at all. I keep getting the same values for all 5 in each
column.

Project_Name Project_Number InScope_PO
InScope_Value
18066 $39,956,652.50
$44,542,301.06
2007 UMTS 19675 $39,956,652.50
$44,542,301.06
RFS Diplexer Swap 19912 $39,956,652.50
$44,542,301.06
2008 UMTS 21412 $39,956,652.50
$44,542,301.06
86299 $39,956,652.50
$44,542,301.06

This is what I get when I view the report. It is showing the same value for
all InScope_PO and InScope_Value values. The report is not working the way I
wanted it to. I need help to figure out how to write the DSum() function so
that each Project Number will have its own InScope_PO and InScope_Value
values.
Any help will be greatly appreciated. Thanks
 
M

Marshall Barton

Ayo said:
This is my situation. I have a report with 4 text boxes.
Box Value
1 =DLookUp("[Project Name]","InScope Table","[Project
Number=Reports!
[Project CV Summary]txtProjectNumber.Value")
2 =Project Number
3 =DSum("[AT&T Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved' AND [Purchase Order
Item]
<>""")
4 =DSum("[Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved'")

Box 2 is txtProjectNumber. The report is group by Project Number. I have 5
Project Numbers. The Project Name and Project Number seem to be working fine,
boxes 1 and 2. My problem is with boxes 3 and 4. The DSum function doesn't
seem to be working at all. I keep getting the same values for all 5 in each
column.

Project_Name Project_Number InScope_PO
InScope_Value
18066 $39,956,652.50
$44,542,301.06
2007 UMTS 19675 $39,956,652.50
$44,542,301.06
RFS Diplexer Swap 19912 $39,956,652.50
$44,542,301.06
2008 UMTS 21412 $39,956,652.50
$44,542,301.06
86299 $39,956,652.50
$44,542,301.06

This is what I get when I view the report. It is showing the same value for
all InScope_PO and InScope_Value values. The report is not working the way I
wanted it to. I need help to figure out how to write the DSum() function so
that each Project Number will have its own InScope_PO and InScope_Value
values.
Click to expand...


There are syntax errors in what you posted so I conclude
that you retyped the expressions and introduced typos in the
process. In the future, please use Copy/Paste so you don't
waste time going back and forth over irrelevant issues.

Since I can't tell what might be wrong in your real
expressions, I'll just offer what I think you should use:

=DSum("[AT&T Extended Price]","InScope Table","[Project
Number]=" & [Project Number] &" AND [Funding Request
Status]='Approved' AND [Purchase Order Item] <>'' ")

=DSum("[Extended Price]","InScope Table","[Project Number]="
& [Project Number] & " AND [Funding Request
Status]='Approved' ")
 
A

Ayo

NO.
I can't just put in
=DSum("[AT&T Extended Price]","InScope Table","[Project
Number]=" & [Project Number] &" AND [Funding Request
Status]='Approved' AND [Purchase Order Item] <>'' ")
The [Project Number] I need for each is the one in the Report's
txtProjectNumber textbox. There are many Project Numbers in the table. Using
the syntax above I will only get one Project Number instead of the five I
currently have.
tim said:
Did you get your problem resolved?

Ayo said:
This is my situation. I have a report with 4 text boxes.
Box Value
1 =DLookUp("[Project Name]","InScope Table","[Project
Number=Reports!
[Project CV Summary]txtProjectNumber.Value")
2 =Project Number
3 =DSum("[AT&T Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved' AND [Purchase Order
Item]
<>""")
4 =DSum("[Extended Price]","InScope Table","[Project Number
=Reports![Project CV Summary]txtProjectNumber.Value" AND
"[Funding Request Status]='Approved'")

Box 2 is txtProjectNumber. The report is group by Project Number. I have 5
Project Numbers. The Project Name and Project Number seem to be working fine,
boxes 1 and 2. My problem is with boxes 3 and 4. The DSum function doesn't
seem to be working at all. I keep getting the same values for all 5 in each
column.

Project_Name Project_Number InScope_PO
InScope_Value
18066 $39,956,652.50
$44,542,301.06
2007 UMTS 19675 $39,956,652.50
$44,542,301.06
RFS Diplexer Swap 19912 $39,956,652.50
$44,542,301.06
2008 UMTS 21412 $39,956,652.50
$44,542,301.06
86299 $39,956,652.50
$44,542,301.06

This is what I get when I view the report. It is showing the same value for
all InScope_PO and InScope_Value values. The report is not working the way I
wanted it to. I need help to figure out how to write the DSum() function so
that each Project Number will have its own InScope_PO and InScope_Value
values.
Any help will be greatly appreciated. Thanks
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with report & subreport 4
Help with a Monthly Summary Report 3

Top