Max records for a Query

  • Thread starter Thread starter SherryLaine
  • Start date Start date
S

SherryLaine

Is there a maximum number of records or sources to include in a query? I'm a
beginner user and am trying to create a query to pull information from five
tables. There are four tables with about 15 records and 7 records from the
fifth table. I've gotten as far as the one table with 7 records and three
tables with the 15 records and can get the query to run. Once I just add the
fifth table without adding records to the query, the query wont run. It
returns nothing. I appreciate any help!
 
More than likely, you are getting no return because you are not linked
correctly. Right click on the link lines and you should have option one, two,
or three. Read those carefully and try and decide exactly what you need from
each table.
 
As already said, you probably have no record in the result because of joins.

Otherwise, there is a limit of 255 fields (in a recordset) and a limit of 32
tables.

Vanderghast, Access MVP
 
The only time the query runs right is when the fifth table is not showing.
I've tried it with each link and no link with the table showing and query
does not run. I delete the table, the query runs. The other four tables are
linked with option 1.

Any guesses???
 
Back
Top