SQL statement problem about inserting record in a single sql view .? MS access?

Question

my professor ask us to code SQL statements to insert the following record for each of the tables.

what I wanted to do is to code all the record in a single sql view what I did was this one and unfortunately It says "characters found after end of SQL statement" or "syntax error on INSERT INTO statement"

now I want this two statements to be coded in a single form I use UNION but doesn't work either ..

INSERT INTO SERVICE (PropertyID,Initials,Date,HoursWorked)
VALUES (1,'LA1','8/28/2012','89');

INSERT INTO SERVICE
VALUES (2,'LA1','8/28/2012','98');




what is the exact or best way to resolve this problem...

Answer 1

Please stop repeating your questions over and over. I already replied to this same question in your earlier post.

Answer 2

INSERT INTO SERVICE (PropertyID,Initials,Date,HoursWorked)

select 1,'LA1','8/28/2012','89'

UNION ALL

select 2,'LA1','8/28/2012','98'

Answer 3

For the assertion you have got to declare which columns you're inserting them into or else it tries to insert the values into all columns. Modify your code to the below: INSERT INTO ballot (query) VALUES ('experiment')