Running Sum!

[Andrew]

The following query runs fine in Access 97 and in 97 mode in Access 2002.



But when I try to use this database in 2002 mode the query doesn't work. I
guess because 2002 does queries differently!



DSum("Qty*Cost","tblItems","ItemID<=" & ItemID &" AND req")



This is based the following table;



Fields Format

Date date

Item text

ItemID numeric

Req yes/no

Qty numeric

Cost currency



The query is supposed to select only those items with the field "Req" set to
yes, which it does, then a simple expression calculates the total based on
these fields "Qty by Cost".



It is then supposed to create a running total for me.



What is going wrong.



Any help much appreciated.

 

[Michel Walsh]

Hi,


Should work... you are still using a JET database (dot-mdb) not an MS
SQL Server project (dot-adp) ?


When you say "doesn't work", you mean there is an error or an erroneous
result?


Vanderghast, Access MVP