Problem of Parameters in INSERT Query

[nilanjangm]

While running a query (in MS Access 2007), the code of which is

INSERT INTO tbl_Resource_Master ( Resource_Last_Name, Resource_First_Name, Resource_Middle_Name, Resource_Mobile_Number )
VALUES ( '[Resource Last Name]', '[Resource First Name]', '[Resource Middle Name]', [Resource Mobile] );

, it's prompting for the number field only.

Can you please help me on this?

[TheSmileyCoder]

INSERT INTO tbl_Resource_Master ( Resource_Last_Name, Resource_First_Name, Resource_Middle_Name, Resource_Mobile_Number ) 
VALUES ( '[Resource Last Name]', '[Resource First Name]', '[Resource Middle Name]', [Resource Mobile] );

I don't know what you think your trying to accomplish with your SQL statement, but I can tell you what it will do.
It will insert the STRING "[Resource Last Name]", not values from a field called [Resource Last Name] (same for the next 2 fields). The reason why its only asking for the number field, is because thats the only field you have not enclosed in single quotes.

If your trying to transfer values from one table to another, you will need to include a FROM statement in your SQL. Where is access supposed to take the values from?

[nilanjangm]

Well, your answer

The reason why its only asking for the number field, is because thats the only field you have not enclosed in single quotes.

provided me with the solution. :)

The code that worked were

INSERT INTO tbl_Resource_Master ( Resource_Last_Name, Resource_First_Name, Resource_Middle_Name, Resource_Mobile_Number )
VALUES (['Resource Last Name'], ['Resource First Name'], ['Resource Middle Name'], [Resource Mobile]);

The single quotes should have been inside square braces, in stead of outside those.

And, what I tried to achieve was to insert three values into the table "tbl_Resource_Master", either running the query directly or executing it from the VBA code, both of which produced same result.

Thanks a lot.