Recent content by Chuck_45

Should work but doesn't any way I have it figured out, you would know this if you wrote in in the Query only to get a Syntax error.

See actually in access is it is wrote INSERT INTO Publisher (PubName, Contact, Phone) VALUES ("READ WITH US", "John Doe", "866-888-9999"); not INSERT INTO Publisher (PubId, PubName, Contact, Phone) VALUES (‘6’,’READ WITH US’,’John Doe’,’866-888-9999’);

I got the solution INSERT INTO Publisher (PubId, PubName, Contact, Phone) VALUES (‘6’,’READ WITH US’,’John Doe’,’866-888-9999’); INSERT INTO Publisher (PubId, PubName, Contact, Phone) VALUES (‘7’,’KNOWLEDGE FOR ALL’,’Jane Doe’,’800-1212-5555’); INSERT INTO Publisher (PubId, PubName, Contact...

Working on this right now; Write an SQL statement to display the publication ID, average retail price, and average cost of all books. Group the output by publication ID. Write INSERT statements to add the following data to the Publisher table...

For sure doesn't hurt to ask for help. Access is being used where I am working with similar inputs alreardy got the statement in the query just that last part as I indicted. INSERT INTO Publisher (PubId, PubName, Contact, Phone) VALUES (‘6’,’READ WITH US’,’John Doe’,’866-888-9999’); INSERT...

I already have the first part done having a problem with the last part; Write an SQL statement to display the publication ID, average retail price, and average cost of all books. Group the output by publication ID. Write INSERT statements to add the following data to the Publisher table...

Actually it isn't homework it's a project I am working on using the example to practice on but Thank you.

Coming from a background of SQL Server and T-SQL, Access is no my favorite. Need to know how: In Access Write an SQL statement to display the publication ID, publication date, cost, and category of each book planned for publication ID number 4. Repeat the previous task but include ID and...

Say hello to every one! Chuck