Dsum

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have a table named tblMinutes, it has 2 field in it, "Number-Books",
TypeMeeting" The field "TypeMeeting" has 4 or 5 types of Meetings in it and
I'm trying to sum the number of books for the type meeting named "Council".
I'm using this code - CBooks:
DSum("[number-Books]",[tblminutes],"[typeMeeting]='council'"). The error
message says this expression is typed incorrectly or it is too complex to be
evaluated. Would someone tell me where me TYPING error is, I can't think up
anything to complex for a computer!!!

Thanks
 
NotGood@All said:
I have a table named tblMinutes, it has 2 field in it, "Number-Books",
TypeMeeting" The field "TypeMeeting" has 4 or 5 types of Meetings in it
and
I'm trying to sum the number of books for the type meeting named
"Council".
I'm using this code - CBooks:
DSum("[number-Books]",[tblminutes],"[typeMeeting]='council'"). The error
message says this expression is typed incorrectly or it is too complex to
be
evaluated. Would someone tell me where me TYPING error is, I can't think
up
anything to complex for a computer!!!

Thanks
Click to expand...

You need to use an = sign instead of a colon in order to successfully assign
the value to Cbooks:

CBooks = DSum("[number-Books]","[tblminutes]","[typeMeeting]='council'")

Also notice I've added quotes around the table name.
 
Back
Top