running totals

[jomarelectric]

access 2002

hello, all..

i need to do a running total.

my invoice field can either startwith "C" (cash sale) or "0" (account). i need only the invoices that startwith "C".

in crystal reports i create a formula like this in my running total:

left({INIH.INVOICE},1) = "C"

can i do something similar in access w/out getting into VB?

 

[Remou]

You can set the control source of a textbox to, say:

[tt]=IIf(Left([Invoice],1)="C",[Amount],0)[/tt]

And then set Running Sum to Over All or Over Group, as appropriate.