<div>
TSUM is not a valid Access function, create a recordset instead of the DSUM
</div>


TSUM is not a valid Access function, create a recordset instead of the DSUM

<div>
<div class="content wysiwyg-content">
Hi, I have such problem: I have to create an application with MS Access, and I found that using the DSUM function is very slow, in order to make the process of data faster I red about replacing DSUM with other function - you called it TSUM. Anyway the TSUM function uses three parameters ,the first one is the name of the field, but in my case it is not a field,but expression and the function doesn't work.Do you have any idea how this problem can be solved? in my case:<br />
tIZRAZ_FRZ = DLookup(&quot;[FRZ]&quot;, &quot;ZAPD&quot;) <br />
tFRZ = DSum(tIZRAZ_FRZ, &quot;ZAPNEW&quot;, &quot;[NOMER] = &quot;&nbsp;&amp; RS!NOMER)<br />
Thanks,Katia
</div>
</div>


Hi, I have such problem: I have to create an application with MS Access, and I found that using the DSUM function is very slow, in order to make the process of data faster I red about replacing DSUM with other function - you called it TSUM. Anyway the TSUM function uses three parameters ,the first one is the name of the field, but in my case it is not a field,but expression and the function doesn't work.Do you have any idea how this problem can be solved? in my case:
tIZRAZ_FRZ = DLookup("[FRZ]", "ZAPD") 
tFRZ = DSum(tIZRAZ_FRZ, "ZAPNEW", "[NOMER] = " & RS!NOMER)
Thanks,Katia

WHEN REPLACED DSUM WITH TSUM - how to use expression instead of the name of the field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.