text DSUM

[ciarra41]

1.I'm getting a error on this-I need to change this to do it using text.

2. Using a date field (Period) can you add and modify it to subtract the last date entered. I'm not sure where to put the "Period" field using what I have below.

DSum("MKTG_COST","MKT","OrderID = " & [ORID] & " And QNID <=" & [QNID]) AS MKTG_RMIND

Thanks so kindly

 

[genomon]

What exactly is the error text?

Ni neart go cur le cheile.