DSUM syntax problem

[Ben2k]

I have this in a textbox

=DSum(Qry_AllFinanceDeals1![Finance Amt],[Qry_AllFinanceDeals1],Qry_AllFinanceDeals1!Company='haydock finance ltd')

When run it just displays #Name?

How can I find out whats wrong?

Ben

 

[bat17]

Try :-

=DSum("[Finance Amt]","[Qry_AllFinanceDeals1]","[Company] = 'haydock finance ltd'")


HTH

Peter

 

[Ben2k]

Thanks Peter,

It now displays #Error

How can I debug it and find out what the error is?

Ben

 

[bat17]

Did you copy my line or retype it? there is a single ' at the end which is not obvious and missing it could give this error

=DSum("[Finance Amt]","[Qry_AllFinanceDeals1]","[Company] = 'haydock finance ltd ' " ) -- Spaced out for clarity.

The other thing that would give this error would be a mis-spelling of any of the field/table names

HTH

Peter

 

[Ben2k]

I copied and pasted your line.

The Qry_AllFinanceDeals1 is a query not a table, will that be okay?

Ben

 

[bat17]

It should work with a query just the same as a table, all I can suggest is double checking spelling, if you are using a totals query the query can rename fields.

as a test you could try running it with out the criteria
=DSum("[Finance Amt]","[Qry_AllFinanceDeals1]")


Peter