Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Access 97 DoCmd Syntax Question

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.
0
Denthion
Asked:
Denthion
1 Solution
 
Rgonzo1971Commented:
Hi,

Shouldn't it be  VALUES

strSQL = "INSERT INTO BlendMix([FPC-ID NUMBER],[Blend Type],[BlendMix],[BlendPercent]) VALUES ('[Blend Type]','[Blend Type]','[Mixd1]','[Percent1]');"

EDIT
as Values you have twice Blend Type is that correct?

Regards
0
 
DenthionAuthor Commented:
Good Catch Thank you
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now