"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
Grouping Names in Mail Merge 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Too many fields defined in select query 4
too many fields defined 2
"Fields Nested Too Deeply" Error in Simple Word Document 5
Error Message 3190?? 1
Too Many Fields Defined 2

Top