DSum Syntax Help

[desk4tbc]

Help! I'm completely at a loss at the syntax for dsum! I have the following:



intSum = DSum("[Amount Paid]","FileList","[Accession Number] = '" & Me![Accession Number] & "'" And Book = Me![Book]")

I'm trying to sum the "Amount Paid" column in the "FileList" table with the conditions that the accession number and the book in the "FileList" table are the same as the values in the form with controls with the same name.

Amount Paid, Accession Number are both stored as numbers while Book is stored as a string. I'm getting an invalid syntax error. Help!

[June7]

Need to concatenate the Me![Book] and assuming [Accession Number] and [Book] fields are text datatype:

intSum = DSum("[Amount Paid]","FileList","[Accession Number] = '" & Me![Accession Number] & "' And Book = '" & Me![Book] & "'")

[desk4tbc]

Thanks! That did the trick after messing with the ' locations.

intSum = DSum("[Amount Paid]", "FileList", "[Accession Number] = " & Me![Accession Number] & " And [Book] = '" & Me![Book] & "'")