Insert Into field

[Guest]

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

 

[Wolfgang Kais]

Hello 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,

What does that mean, "click on the market segment"?

... 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

"Doing labels" surely means "Create a label report using the wizard".
Why sould there be an INSERT statement involved? I guess that you are
using a custom database application that nobody out here knows, sorry.

 

[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

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]