DSum Problem

[dim]

Hi,

I have a query named BBT with those fields:
Qty, S_Time, M_Time, Planned_Date

I need to calculate in a new field AT:
DSum("[TT]","BBT", [Planned_Date]<=#" & [Planned_Date] & "#")
but for some reasons doesn't work.

The field TT is a calculated field too;
TT: [S_Time]+ (Qty]*[M_Time]

Can you please help with the right expression DSum to calculate the AT ?

Thank you!

 

[plog]

Count your parenthesis.

 

[plog]

Actually, that's only the syntatical error. You also have a circular logic error as well.

You are not going to be able to do a DSum into the query the Dsum is in. You must either rewrite the DSum to use the underlying table of the query (along with its criteria). Or save BBT and then create another query based on it and do the DSum there.

 

[dim]

Thank you,

You right!
Using another query, is working.