Access 97 DoCmd Syntax Question

Denthion
Denthion used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
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

Author

Commented:
Good Catch Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial