DSUM Problem

[Trevor G]

I am trying to use a DSUM on a form but it is giving me an error message. Any help would be appreciated. The details are:

I want to look at the total value for a field called Annual_Prem in a table called Layers_In_Quotation summing against the qoutationNumbers field which gives the id. I thought the following would work:



=DSum("[annual_prem]","Layers_In_Qoutation","[QuotationNumber]")

 

[jackd]

I am trying to use a DSUM on a form but it is giving me an error message. Any help would be appreciated. The details are:

I want to look at the total value for a field called Annual_Prem in a table called Layers_In_Quotation summing against the qoutationNumbers field which gives the id. I thought the following would work:



=DSum("[annual_prem]","Layers_In_Qoutation","[QuotationNumber]")

Looks like a spelling problem - Layers_In_Qoutation
or perhaps you need more in the criteria section
eg "QuotationNumber >0" or similar