Insert Into Values Question

[NeonSky via AccessMonster.com]

Hi,

This works....

INSERT INTO tblFileTypeDateExport (FileName)
VALUES ('A0-' & Format(Date(),'mmddyyyy') & '.xls')

This Does not....

INSERT INTO tblFileTypeDateExport (FileName)
VALUES ('A0-' & Format(Date(),'mmddyyyy') & '.xls'), ('B0-' & Format(Date(),
'mmddyyyy);

Why?

Thanks for thinking about my question!

 

[NeonSky via AccessMonster.com]

Never mind, got it sorted out!

 

[Marshall Barton]

This works....

INSERT INTO tblFileTypeDateExport (FileName)
VALUES ('A0-' & Format(Date(),'mmddyyyy') & '.xls')

This Does not....

INSERT INTO tblFileTypeDateExport (FileName)
VALUES ('A0-' & Format(Date(),'mmddyyyy') & '.xls'), ('B0-' & Format(Date(),
'mmddyyyy);

You forgot to specify the field for the second value.

INSERT INTO tblFileTypeDateExport (FileName, somedield)
Values(. . .