What's wrong with this expression?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
Andrew said:
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.
Click to expand...
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
 
Whoops...missing final parenthesis.

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

Gary Walter said:
Andrew said:
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.
Click to expand...
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
Click to expand...
 
Gary, sorry I stll get an #Error


Gary Walter said:
Whoops...missing final parenthesis.

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

Gary Walter said:
Andrew said:
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.
Click to expand...
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
Click to expand...
Click to expand...
 
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

Andrew said:
Gary, sorry I stll get an #Error


Gary Walter said:
Whoops...missing final parenthesis.

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

Gary Walter said:
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
Click to expand...
Click to expand...
Click to expand...
 
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!
 
Back
Top