What's wrong with this expression?

[Andrew]

Sum: Format(DSum("Qty*Cost","tblItems","ItemID<=" & [ItemID] & " AND
req"),"£#,##0.00")

Futher information.

Access 2002.
Based on the following table tblItems.
Query uses another expression qty*cost to produce a total.
The Query is supposed to produce a running sum based on the field "req" set
to yes.

Thanks in advance.

Andy

 

[Gary Walter]

Sum: Format(DSum("Qty*Cost","tblItems","ItemID<=" & [ItemID] & " AND
req"),"£#,##0.00")

Futher information.

Access 2002.
Based on the following table tblItems.
Query uses another expression qty*cost to produce a total.
The Query is supposed to produce a running sum based on the field "req" set
to yes.

Hi Andrew,

Would you mind humoring me
and test the following construction
(I could be all wet)

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)"

Thanks,

Gary Walter

 

[Gary Walter]

Whoops...missing final parenthesis.

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)")

Sum: Format(DSum("Qty*Cost","tblItems","ItemID<=" & [ItemID] & " AND
req"),"£#,##0.00")

Futher information.

Access 2002.
Based on the following table tblItems.
Query uses another expression qty*cost to produce a total.
The Query is supposed to produce a running sum based on the field "req" set
to yes.

Hi Andrew,

Would you mind humoring me
and test the following construction
(I could be all wet)

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)"

Thanks,

Gary Walter

 

[Andrew]

Gary, sorry I stll get an #Error

Whoops...missing final parenthesis.

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)")

Sum: Format(DSum("Qty*Cost","tblItems","ItemID<=" & [ItemID] & " AND
req"),"£#,##0.00")

Futher information.

Access 2002.
Based on the following table tblItems.
Query uses another expression qty*cost to produce a total.
The Query is supposed to produce a running sum based on the field "req" set
to yes.

Hi Andrew,

Would you mind humoring me
and test the following construction
(I could be all wet)

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)"

Thanks,

Gary Walter

 

[Gary Walter]

Hi Andrew,

I might try "divide and conquer"
to find what it is choking on.

try

DSum("[Qty]","tblItems")

DSum("[Qty]*[Cost]","tblItems")

DSum("[Qty]*[Cost]","tblItems", "([req]= -1)")

DSum("[Qty]*[Cost]","tblItems", "(ItemID<=" & [ItemID] & ")")

Please post back if all these work properly.

Gary

Gary, sorry I stll get an #Error

Whoops...missing final parenthesis.

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)")

Sum: Format(DSum("Qty*Cost","tblItems","ItemID<=" & [ItemID] & " AND
req"),"£#,##0.00")

Futher information.

Access 2002.
Based on the following table tblItems.
Query uses another expression qty*cost to produce a total.
The Query is supposed to produce a running sum based on the field "req" set
to yes.

Hi Andrew,

Would you mind humoring me
and test the following construction
(I could be all wet)

DSum("[Qty]*[Cost]","tblItems",
"(ItemID<=" & [ItemID] & ") AND ([req] = -1)"

Thanks,

Gary Walter

 

[Michael Hopwood]

Try changing the field name from "Sum" to "MySum", if this fixes it then you
can assume that "Sum" is a reserved word and should not be used for field
names!