Insert Into Values Question

  • Thread starter Thread starter NeonSky via AccessMonster.com
  • Start date Start date
N

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 said:
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);
Click to expand...


You forgot to specify the field for the second value.

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