Insert Into field

A

atwoodadmin

Trying to do labels out of access ( I believe it is the 2003 version). When I
click on the market segment I want to make labels for, I get the following
message: The INSERT INTO statement contains the unkown field name: 'Account
Type' make sure you have typed the name correctly and try the operation
again. How do I fix this? Thank you
 
J

John W. Vinson

Trying to do labels out of access ( I believe it is the 2003 version). When I
click on the market segment I want to make labels for, I get the following
message: The INSERT INTO statement contains the unkown field name: 'Account
Type' make sure you have typed the name correctly and try the operation
again. How do I fix this? Thank you
Click to expand...

This means that whatever it is that you're clicking - and Access does NOT have
a "Market Segment" feature, that's something specific to your application - is
trying to run a MakeTable or Append query; this query is trying to put data
into a field named [Account Type], and the table has no such field.

This is not a problem with Access per se; it's a problem with the particular
Access application that you're using. Correct the error, or contact the person
who wrote the application and get them to do so; or post some more details
about what it is that you're clicking, perhaps we can help debug it.

John W. Vinson [MVP]
 
Top