SQL to Insert text fields problem

[Robert Blair via AccessMonster.com]

I'm using Access 2K. I have a concatenation function which creates a memo
field. I'm trying to write the resulting values to tblFN_Children. The
three values are:

FN - string which represents the file number with the format "NN-NNN"

NamesDOB - Memo which is the string created from the execution of the
concatenation function

i - Integer which is the count of the number of children in this FN

All works well until I get to the Insert. My command is

DoCmd.RunSQL ("INSERT INTO tblFN_Children ( FileNumber, Children,
NumberofChildren ) " & _
" SELECT '" & FN & ",' '" & NamesDOB & ",' " & i)

When I Debug, the values for FN, NamesDOB and i are correct, it seems to be
that my SELECT statement is not in the correct syntax, but I'm lost.
I'm getting a runtime #3075 error - Missing operator.

What am I doing wrong?

 

[Douglas J. Steele]

Your ",' '" and ",' " appear to be incorrect.

They should be "', '" and "', " (where, exagerated for clarity, that's " '
, ' " and " ' , ")

 

[Robert Blair via AccessMonster.com]

Douglas:

That did it. Mucho Gracias me amigo.

Robert