View Full Version : Insert into query


melios64
08-22-2009, 06:57 AM
Hi guys i am trying to execute this query on access but it fails, any hint?

INSERT INTO Months_Paid ( Studend_Studend_ID, Class_Class_ID, September) VALUES ( 52, 3, 0 )

Studend_Studend_ID is Number field
Class_Class_ID is Number field
September is Yes/No field

Uncle Gizmo
08-22-2009, 12:40 PM
Is there an error message?

Please could you create a Select SQL statement that shows just those three fields in a query and post the SQL form of the query to the forum.

melios64
08-23-2009, 06:51 AM
I figure it out, there was nothing wrong with the query. Thanks a lot anyway!