Having Trouble with Sum in a Query

R

ryguy7272

This is in the Field line:
MTD Delivery:
Sum(IIf([NOV]>0,[C2_UnionQuery2008]![Current_Revenue]/[C2_UnionQuery2008]![NOV],0))

This is in the Total Line:
Expression

It is causing an error: Subqueries can not be used inn the expression...etc.
If I choose Group By for the Total Line, it works, but I need to Count items
in another part of the Query and group these items, which are all similar,
and this MTD Delivery Field is preventing my final query from showing a nice
and orderly Subtotal in the Count Field.

The same thing is happening here:
Proj Delivery: [MTD Delivery]/[Date]*92

I want to Sum this Field, but only Group By in the Total Field works.

Any ideas?


Thanks!
Ryan---
 
L

Lord Kelvan

can you post your entire sql for that query in here by selecting view
in the menu then sql view

Regards
Kelvan
 

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

SQL Query Problem 6
SUM in a UNION query 2
Calculate MTD and YTD in a query 8
Sum different fields in a query 4
Generating system date in Query 2
simple Query, using NZ, is Double-Counting Revenue Numbers 5
Group by and Sum in same query 10
Running Sum in query 1

Top