Crystal 2008 SQL Command getting error Characters Found Ater End Of SQL Statement

I am working through a tutoriail in my Crystal book on how to update a table to keep track of when a report was last run.

Using Crystal 2008. Trying to insert into an Acesss 2010 table. Below is the statement.

Error Message: Characters found after end of SQL statement.

Anybody know why I am getting this error? Thanks.

INSERT INTO ReportHistory
(ReportName,ReportDate)
VALUES
('Reprot History Subreport', GetDate());
SELECT 1 AS Dummy
MidWestGirlAsked:
Who is Participating?
 
GJParkerCommented:
Also just noticed the GetDate() function, this is a SQL server function not used in Access so I assume your book example is for SQL Server and not Access
0
 
GJParkerCommented:
Access doesn't support running multiple SQL statements in one query, you'll need to use a server databse such as SQL server.
0
 
mlmccCommented:
I believe this tool can help solve your problem

http://www.milletsoftware.com/visualcutBenefit.htm

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.