<div>
<div class="content wysiwyg-content">
I have a syntax error in these statements please help<br />
If In1a &gt;&nbsp;&quot;&quot; Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strSQL = &quot;INSERT INTO BlendMix([FPC-ID NUMBER],[Blend Type],[BlendMix],[BlendPer<wbr />cent]) VALUE ('[Blend Type]','[Blend Type]','[Mixd1]','[Percent<wbr />1]');&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DoCmd.RunSQL strSQ<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thank you<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DWG.
</div>
</div>


I have a syntax error in these statements please help
If In1a > "" Then
                strSQL = "INSERT INTO BlendMix([FPC-ID NUMBER],[Blend Type],[BlendMix],[BlendPercent]) VALUE ('[Blend Type]','[Blend Type]','[Mixd1]','[Percent1]');"
                DoCmd.RunSQL strSQ
                End If
                          Thank you
                                  DWG.

Access 97 DoCmd Syntax Question

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.