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
('Reprot History Subreport', GetDate());
SELECT 1 AS Dummy