help with insert

[jamie]

I am trying to insert information into a table and It's not working. Here is the statement I have been working on for two hours

INSERT INTO tblCondoCopy ( CondoNumber, CondoAddress, AcceptsPets, BuildingName, BedroomCount, ViewType )
VALUES ("P99", "S747", "1", "The Shores", "3", "Ocean View");

when I check the query, It puts in the values but changes the field names to Expr1000, Expr1001,1002 and so on

[Rainlover]

I do not understand your objective. More especially why you would Hard Code the Values you wish to Insert.

Can you post a copy of you Database in 2003. I do not use 2007.