"Too many fields defined" Error 3190

A

AccessIM

I keep receiving an error message when trying to run a query.

The query pulls from two tables: Sheet 1 which is information imported from
an Excel spreadsheet and tblItemFiles which is a table imported from an ODBC
database.

I created a relationship between the two tables using the Item Code field
and only have six fields from the tables and two calculated fields.

Does anyone know why this would be happening?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RUNTIME ERROR 3190 - too many fields defined...?? 4
Too many fields defined in select query 4
Queries with Linked Tables 5
Make Table Query Truncating Memo Field at 255 Characters 2
Query with too many fields 7
multiple one to many 2
too many fields defined 2
Append two tables into a query 1

Top